System and method for multiple level architecture by use of abstract application notation

ABSTRACT

A system and method of translating an abstract notation of an application to a series of sub-applications representing a central application. Also described is a multi-tier application system for generating the central application for deployment on a predetermined combination of selected components. The system comprises an abstract notation description file to contain data for the central application. The system also has an application editor for entering a selected set of input parameters to provide the data, and an application generator for transforming the data from the abstract notation to a selected platform notation corresponding to the selected components. The selected notation is contained in the central application, wherein the deployment of the central application monitors the communication of component data between the selected components. The sub-application can be generated for a variety of computer platforms or languages for deployment on an n-tier system, as directed by the intended components. The central application can be applied to distributed web data-centric application.

[0001] The present invention relates to methods and systems for the transformation of languages and computer platforms.

BACKGROUND OF THE INVENTION

[0002] Software capabilities and requirements are rapidly advancing in the present field of computer technology. Companies all over the world desire robust and versatile software solutions to help their businesses expand and excel. However, in spite of overwhelming demand, many companies find that the available software solutions are limited in selection, and that the software solutions are generally developed to support only one programming platform. Accordingly, many companies are struggling with a wide variety of choices for client platforms, transaction servers, and data base systems, while at the same time facing the challenge of integrating them all into one working solution. In general, software applications interact with objects, which are a collection of procedures defining a procedural logic of the application. It is desired that these objects can be used by multiple applications and systems, however this ability is typically limited because objects tend to be designed as platform specific. Accordingly, an object designed for one application that functions on one platform may not be easily accessible by another software application written for a different platform. Therefore, this limitation has made the sharing of objects across different systems and platforms difficult, thus making the sharing objects over an Internet environment problematic.

[0003] In the past, many programming languages and applications have been developed for use in computation. Early languages were often very closely tied to the physical hardware of the device being programmed. As the complexity of software grew, it became advantageous to develop systems which abstracted away most of this complexity from the user. Accordingly, the need for adaptability in software applications has intensified in the past few years, as a result of the growth of the Internet, from a large number of companies attempting to extend their business practices to the World Wide Web. Companies of today are concerned with providing highly distributed software applications that are fully accessible over the Internet. Accordingly, users of the company services expect to access their data from any number of devices such as wireless hand held devices, web browsers, and their desktops, regardless of the operating system they are implementing. Accordingly, software programmers today must often develop and customize the same application several times in a variety languages to work in these different environments. Attempts have been made to run the same program somewhat modified for different platforms, however this typically results in a poor output as the code is not optimized to the constraints of each and every target machine to which it is applied. For example, the desire to run a rich desk top application but on a light weight hand held device.

[0004] A further problem is that many companies wish to adapt their existing software systems, such as Legacy applications with character based interfaces and hardware, to scalable Internet enabled modem systems. Accordingly, shifting from Legacy based applications typically involves choosing between continuing to develop new code on an expensive antiquated system, or getting rid of existing equipment and purchasing new adaptable hardware and corresponding software applications.

[0005] In view of the above discussed application constraints, there have been several approaches in the past used to simplify application development for multiple platforms. The earliest attempts were centered around a preprocessor, which is a straight forward device that takes an input file written in a specific software language, containing not only language specific statements but also preprocessor directives. The directives helped the user to create macros or short hand phrases which represented more complicated constructs. In turn, more complicated directives were developed to allow the porting of applications from one computer system to another. However, the main draw back to preprocessors is that the source code is interspersed with preprocessor directives, which becomes more complicated to read. In addition, the underlying complexities of the different platforms, while dealt with, are no way hidden from the user, thereby requiring the user to determine which portions of their code must be modified for the various selected platforms. This can be a labor intensive and accordingly costly procedure.

[0006] A second generation of software tools was developed to isolate the user from details of the underlying architecture. The second generation tools were more intelligent allowing the user to specify segments of their code in a language independent format. The source code was then passed through a preprocessor where dependent code was added to the source file, examples of which include SQL pre-compilers. However, pre-compilers are generally limited to a section of the source code which is capable of being written in the independent format. This process helps to remove the underlying details of language specific libraries but does not substantially reduce the volume of code necessary to write a given application.

[0007] A further attempted solution to the transport of an application to multiple platforms is translators. Many translation routines exist which allow one language to be converted to another, which fall into the two broad categories of natural language systems and artificial language systems. However, in natural language systems exact translation can be difficult to obtain and therefore probabilities and pattern matching must be used. Although, this approach is unacceptable for computer languages as the translations must be deterministic and accurate. Accordingly, artificial language systems have focused on translation from one known language to another by a well understood medium. The construction of translators, so that language specific code is modularized and reusable, is generally accomplished by parsing the input program and constructing a single or series of abstract syntax trees. The syntax trees represent a language independent view of the operations at a low level. The translation process involves first manipulation of this representation and then reversal of the process, which is generating the translated code from the syntax tree. One example of this process is taught by U.S. Pat. No. 6,031,993 by Andrews et al. This patent describes a method, system, and apparatus for translating one computer language to another using a doubly routed tree data structure. The structure is a combination of two sets of hierarchical related objects sharing a common set of leaves. The object of the patent is to provide a method and apparatus for automatically translating the source code from one high level computer language to the source code of another language. However, the construction of the routed tree structures is performed on a source code by source code basis. This can be a relatively expensive approach as the code must be broken down and then re-assembled. A second disadvantage is that it is difficult for humans in understanding the abstract representation, wherein the interpretation of a single line of code could involve numerous nodes.

[0008] A more recent approach to solving portability concerns has been the advent of virtual machine based architecture, wherein virtual instructions are executed by converting them into real instructions which can be executed on the actual machine. Several such architecture exist today, from interpreting bit codes at a hardware level to application servers which dynamically re-interpret their source documents depending upon the calling process requirements. However, one disadvantage to these interpretative systems is that substantial performance penalties are imposed by them as each time the system is accessed, the translation of the calls must be done anew. This has to a certain extent been mitigated by the use of cashing architectures but performance penalties still remain.

[0009] It is an object of the present invention to obviate or mitigate some of the above presented disadvantages.

SUMMARY OF THE INVENTION

[0010] According to the present invention there is provided a multi-tier application system for generating a central application for deployment on a predetermined combination of selected components. The system comprises:

[0011] a) an abstract notation description file to contain data for the central application;

[0012] b) an editor for entering a selected set of input parameters to provide the data; and

[0013] c) an application generator for transforming the data from the abstract notation to a selected platform notation corresponding to the selected components, the selected notation contained in the central application;

[0014] wherein the deployment of the central application, monitors the communication of component data between the selected components.

[0015] According to a further aspect of the present invention there is provided a method for generating a central application for deployment on a predetermined combination of components selected from a multi-tier environment. The method comprises the steps of:

[0016] a) selecting input parameters for representing data for the central application;

[0017] b) combining the input parameters for producing and abstract notation description file comprising the data;

[0018] c) transforming the data from the abstract notation to a selected platform notation corresponding to the selected components; and

[0019] d) generating the central application containing the platform notation;

[0020] wherein deployment of the central application monitors the communication of component data between the selected components.

[0021] According to a still further aspect of the present invention there is provided a computer program product for generating a central application module for deployment on a predetermined combination of selected components. The product comprises:

[0022] a) a computer readable medium;

[0023] b) an abstract notation description module stored on said computer readable medium for containing data for the central application module;

[0024] c) an editor module coupled to the description module for entering a selected set of input parameters to provide the data;

[0025] d) an application generator module coupled to said description module for transforming the data from the abstract notation to a selected platform notation corresponding to the selected components; and

[0026] e) the central application module coupled to the generator module for receiving the selected platform notation;

[0027] wherein the deployment of the central application module monitors the communication of component data between the selected components.

BRIEF DESCRIPTION OF THE DRAWINGS

[0028] These and other features of the preferred embodiments of the invention will become more apparent in the following detailed description in which reference is made to the appended drawings by way of example only, wherein:

[0029]FIG. 1 is a block diagram for an abstract notation architecture system;

[0030]FIG. 2 is a block diagram of the application development system of FIG. 1;

[0031]FIG. 3 is a diagram of parameters of the system of FIG. 2;

[0032]FIG. 4 is a middle ware component of FIG. 1;

[0033]FIG. 5 is a further middle ware component of FIG. 1;

[0034]FIG. 6 is a sample interface of the system of FIG. 1;

[0035]FIG. 7 is a block diagram of custom querying of FIG. 1;

[0036]FIG. 8a, b, c, d, e, f is an example Application Editor of the system of FIG. 1;

[0037]FIG. 9 is a further example of the Editor of FIG. 8;

[0038]FIG. 10 is an implementation of an application of FIG. 2;

[0039]FIG. 11 is an example deployment of the system of FIG. 1;

[0040]FIG. 12 is a block diagram of the operation of the system of FIG. 2; and

[0041]FIG. 13 is a further embodiment of the system of FIG. 2.

DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0042] Referring to FIG. 1, a general n-tier application system 10 consists of a first tier 14 comprising a client side system or user interface 18 for interacting with an end tier system 16, in this case a third tier, comprising a data source 20 a, b for the storage and retrieval of data. The user interface tier 14 is the visible part of the system 10 that can be manipulated by the user, generally involving the entering and displaying of data. The user can thereby manipulate multi media files through the interface 18, and can also upload, download, view, or otherwise manipulate the files contained in the databases 20 a, b. Accordingly, the end tier 16 can be used to store user critical data on a long term basis for intermittent or continuous retrieval by the user through the user interface tier 14. Database access or user interface devices 18 of the tier 14 can include various data communication devices, such as but not limited to desktops 18 a, applets 18 b, 18 d, wireless hand held devices 18 c, mobile computers, pagers, and other PDAs for accessing the data sources 20 a, 20 b located in the end tier 16. It should be noted that each of the access devices 18 uses a corresponding device platform or software 19 a, b, c, d for coordinating the access of the device or user interface 18 a, b, c, d with the selected data source 20 a, 20 b. The data sources 20 a, 20 b each use a corresponding communication protocol 21 a, 21 b for coordinating the entering and retrieval of their data through a network 22 accessible by the first tier 14. The network 22 can be comprised of local area networks or global area networks such as the Internet. Examples of some of the networks 22 can include synchronous optical networks (SONET), synchronous digital hierarchy (SDH), a synchronous transfer mode (ATM) networks, microwave and antenna bay stations, satellite networks, and networks comprising a mixture of these technologies. Furthermore, the networks 22 can include such things as routers, or other interconnected segments that range from copper wire to fiber optic cable to microwave links.

[0043] The application system 10 can consist of the two tiers 14, 16 as described above, whereby the network 22 would be essentially a single network using a pass through system 24. This system 24 can provide direct data architecture to the system 10 to help provide high speed data access with reduced system 10 complexity and cost. However, a middle tier 26 can be added to the system 10 for providing predetermined business logic and addressing security and scalability concerns of the system 10. Accordingly, the middle tier 26 can be used to focus on the programming of business logic and to provide for scalability and security requires as the system 10 is adapted to changing needs. One subset of the middle tier 26 is the pass through architecture 24 for implementing a two tier 14-16 application model 10. Other components in the middle tier 26 can include middle ware applications or servers 28 a, b, which can include such as but not limited to a Component Object Model (COM) and Enterprise Java Beans (EJB). These middle ware components 28 a, b function by helping to hide details of running multiple transactions from the first tier 14, as well as managing and pooling resources to address performance issues, such as scalability, dynamic load balancing, and failover capabilities. Accordingly, the middle ware components 28 a, b can scale the ability of the system 10 to meet growing demands, distribute and balance processing capabilities between servers, and reroute capabilities should selected servers cease to function. The middle tier 26 is situated between two networks 22 to facilitate the implementation of the middle ware processes between the first tier 14 and end tier 16. It should be noted that each of the middle tier 26 components 24, 28 a, b includes a selected platform or software 25, 29 a, 29 b for coordinating the distribution of the data 20 a, b from the end tier 16 to the device 18 of the first tier 14. It should be noted that the platforms 19 a, b, c, d, 21 a, b, 25, and 29 a, b can use differing languages and protocol structures.

[0044] The various platform components 19 a, b, c, d, 21 a, b, 25, and 29 a, b are provided by a central platform application 30, which is generated by an application development system 12. The system 12 can generate the application 30 for a variety of platforms, such as a series of graphical user interfaces connected to selected databases 20 a, b. The central application 30 can contain a series of sub-applications 32, 34, 36 which may or may not be in the same programming language or customized for the same software platform or common hardware systems 18, 28, 20, thereby helping to provide an end-to-end n-tier application 30. Accordingly, the central application 30 provides the series of sub-applications 32, 34, 36 to be deployed on various tiers 14, 16, 26 for providing support for a selected combination of components contained in the tiers 14, 16, 26, which can be used by a company to integrate the selected components from the tiers 14, 16, 26 into one working solution on a variety of platforms. The sub-applications 32, 34, 36 are developed to provide the platforms 21 a, b, 25, 29 a, b, and 19 a, b, c, d respectively. The system 12 contains a central or abstract application description file 38 constructed using a series of input parameters 40, which is then directed into an application generator 42, which operates on a series of selected inputs 44 containing particulars about the selected combination of components from the tiers 14, 16, 26 of the system 10. The file 38 can represent an abstract declaration of a graphical user interface for deployment on the device 18. The application generator 42 constructs the sub-applications 32, 34, 36 of the central application platform 30, based on the file 38, thereby providing a predetermined combination of platforms 19 a, b, c, d, 21 a, b, 25, and 29 a, b to facilitate the access of a particular device 18 in tier 14, through the networks 22 and selected middle ware components 24, 28 of the middle tier 26, through to the selected databases 20 a, b of the end tier 16. Accordingly, the user of a particular device 18 can then retrieve data from the databases 20 a, b review, modify or alter the data, and then save the changes to the original or alternate selected database 20 a, b. It should be noted that the generator 42 can generate multiple versions of the file 38 to be applied to a variety of hardware components in the tiers 14, 16, 26, which is represented by the subprograms 32, 34, 36 of the application 30. Accordingly, the file 38 can be designed to provide a similar look and feel to the user of various devices 18 across the various hardware software platforms, such as but not limited to HTML for browser and WAP for hand helds.

[0045] Referring to FIG. 2, the system 12 is used to generate the central platform application 30 from the abstract language input file 38. The file 38 is then separated across the several related output files 32, 34, 36, thereby providing database interface platforms 21 a,b, application server platform files 25, 29 a, b and user interface platform files 19 a, b, c, d. It should be noted that each of these platform files 19 a, b, c, d, 21 a, b, 25, and 29 a, b can be generated in a different language for a pre-selected deployment combination (see FIG. 11 and corresponding description below). The input parameters 40 to the application file 38 can include designing of the application using an application editor 46. The application editor 46 facilitates the input of declarations into the file 38, as well as previewing previously entered declarations. Preferably, these declarations are stored in an XML format. Furthermore, internationalized strings can be added for functionality in multiple languages. The parameters 40 can include the addition of application business logic 48, including such things as neurons and reports to provide predetermined functionality to the central application platform 30. The neurons are an application of event based architecture and can be used to provide architecture that receives interprets, and sends messages. The neurons facilitate the specification of arbitrary behaviors for the platform 30 and are preferably programmed in the XML format. The reports and associated recursive report style queries of the business logic 48 allow manipulation and access to summary data, such as reporting via parent/child relationships of the data on the databases 20 ,a b.

[0046] The parameters 44 can include selection of a client or device type 50, which indicates the device type 18 a, b, c, d accordingly. If the device type needs change, thereby requiring a new interface, the application designer can change the device type independently the other input parameters 40, 44. The parameters 44 can include a selection of middle tier technology 52, which facilitates the separation of business logic of the application presiding in the middle tier 26 from the functionality of the interfaces in the first tier 14. Security, scalability, and reliability parameters can be designed into the application 30 using these input parameters 52. For example, the parameter 52 can include specifications for middle tier architectures comprising EJB and COM, whereby communication with the middle tier 26 can be achieved by using Simply Object Access Protocols (SOAP) or the pass through parameters 24 can be designed thereby providing a traditional client-server two-tier architectural model. The parameters 44 can also include a data source selection 54 or the construction for a customized data source. The data storage tier 16 is were the data sources 20 a, b are located. These databases 20 a, b can be an SQL-compliant database such as the SQL server 7, Sybase adaptive server, or MySQL, as well as a variety of non-SQL data sources such as flat files, Legacy databases, and XML.

[0047] Further input parameter 44 can be security requirements 56, which can be based on multiple levels of security to provide a predetermined safety level of access to and from the data sources 20 a, b. These parameters 56 can provide high level concurrency control, insulation of databases 20 a, b behind corporate firewalls, and query security models for specification of clearance levels by the client company. Example aspects of the security parameters 56 can include user level security, web security, data security, and an application service provider (ASP) model compliance. Furthermore, industry standard 128 bit or higher Secure Socket Layer (SSL) encryption can be used. It should be noted that the input of the parameters 40, 44 is not limited to the corresponding specific input destinations 38, 42 as described above. Accordingly, alternate combinations of input parameters 40, 44 to either the file 38 or the generator 42, or other combinations thereof can be used by the system 12, depending upon the needs of the software developer to generate the central platform file 30. Accordingly, once the generator 42 has generated a source code file 30 for a selected component combination of inputs 40,44 representing the entities contained in the tiers 14, 16, 26, the file 30 can then be passed to a specific language compiler, such as Java or C based, to build an executable code. It should be noted that this computation stage could also be accommodated by the generator 42, thereby providing an executable application file 30 for deployment on a selected configuration of the n-tier application system 10.

[0048] End Tier Systems

[0049] The data source selection parameters 54 of the input parameters 44 can be used to define the particular selected protocol platform 21 a, b, as described by the sub-application file 32 of the central application platform file 30. The data sources 20 a, b and associated protocols 21 a, b can be selected from any system that can be used to store data from which a predetermined access level is monitored. The most common types of data sources 20 a, b are based on Structure Query Language (SQL), commonly referred as SQL sources. These sources can include MySQL which is an open source software that can be used as a readily available database management system, of which the source code can be download, used, and modified to fit the individual needs of the user. Another SQL source is SQL Server 7, which can be used to interact with the Microsoft COM objects and other Microsoft based technologies. Sybase is a further data source 20 a, b providing a custom query system typically used in high end database solutions that are designed on unique bases. Furthermore, a Freedom Intelligence 20 a, b source can be used as a read only database solution that can be optimized for executing SQL queries.

[0050] In addition to SQL based databases 20 a, b, the software development system 12 can also support a variety of non-SQL sources involving custom query systems, such as but not limited to flat-files, Legacy databases, and extensible markup language (XML). The flat files can represent a database, tree, or network structure such as a single file from which the structure can implicitly be rebuilt and modified. Legacy databases 20 a, b are commonly known in the art, and typically represent older and highly customized data sources 20 a, b. The system 12 can also utilize XML as a data source 20 a, b by presenting data in a corresponding database structure.

[0051] Tradition storage values for databases 20 a, b can include numbers and strings. A Binary Large Object (BLOB) specification, which can be found in SQL 92, further enables the storage of images, sound, video, and any other form of computer media in a database. Accordingly, the system 12 can also use a BLOB column to hold an arbitrary string of bits. For example, BLOBs can be used to store a variety of file types, including multi media files and images, whereby all these elements are stored in the selected database 20 a, b. Accordingly, web pages can be generated from a series of elements stored on the database 20 a, b, including such data as an author, price, picture of a book cover, summaries, and customer reviews, such as for an application 30 for database access system 10 of an online book store. BLOBs can also be used to build document management systems, such as storing documents in the database 20 a, b so that various individuals can share the materials contained therein. Furthermore, BLOBs can also be applied to facilitate the storage of CAD diagrams and other imagery data. The use of BLOBs can also be used to handle BLOB files of unknown types by writing custom entities to view custom file types by the devices 18 of the system 10.

[0052] Security Components

[0053] The security requirement parameters 56 of the input parameters 44 can be used to monitor the passing of private and confidential information, such as but not limited to credit card numbers, personal addresses, and phone numbers, as monitored by the central application 30 for the associated tiers 14, 16, 26 and devices therein of the system 10. The parameters 56 can also be used to specify security settings for individual fields, tables, and other widgets 60 (see FIG. 6) used in the interface of the device 18. Since any advanced system 10 could potentially exhibit multiple instances of vulnerability, making such systems 10 containing elevated levels of complexity more prone to security holes. Accordingly, the parameters 56 could be used to specify user level security details, web security issues, and data security issues. Further to user level security, passwords could be assigned or login process on the device 18 to distinguish different users having different data access levels. Pre-existing queries could be specified to execute based on the security clearance granted to each individual user, which would allow the user to view and modify confidential data on the databases 20 a, b while inhibiting other non-associated users from having the same accessibility. The web security can use 128 bit or higher Secure Sockets Layer (SSL) encryption to provide secure access to data over the Internet 22. Accordingly, example applications 30 such as those based on JAVA Server Pages (JSP) platform can be used in connection with the SSL security standard (see example application as detailed below). The data security can be used to address such issues as the use of firewalls and the use of encryption between entities such as database servers 28 a, b.

[0054] In addition, the Application Service Provider (ASP) system model can generate specific security concerns. Accordingly, a User/Company/Application security model can be used to provide the separation of individual client data from one another. This model can include the parameters 56 such that each user belongs to a single company and each company has a separate database 20 a, b. When a particular user (belonging to a particular company) logs into an application using the device 18, the user is given access to the companies database 20 a, b as specified in the central application platform 30. If the company has access to multiple applications, then the data 20 a, b for every application can be shared, facilitating intra operability between applications. It should be noted that the data security parameters 56 can be used to specify security requirements in two tier architectural models where the device 18 can access the database 20 a, b directly, or in middle or multiple tier architectural models which makes use of the middle tier 26 and transaction servers 28 a, b. Accordingly, the security features of the application platform 30 can reside in any one of the sub-application platform files 32, 34, 36, depending upon the desires of the company and design parameters 40, 44 designated by the software designer during construction of the central platform application 30.

[0055] The security parameters 56 can be setup to determine that once a login has occurred through the interface of the device 18, the user name supplied is used to lookup the appropriate handle for the user. As well, the application name is used to fetch the appropriate handle for the selected database 20 a,b access desired. The user handle and application id can then used to fetch the correct group for security permission lookup for each entity listed in the application 30. Security permissions that are fetched are then applied to all entities in the program 30, determining what buttons, screens, etc. the user can view, as well as what text fields, grids, etc. the user can modify. As well, the user handle and the application id are further used to fetch any customized settings the user may have in the system 10, as defined by the central platform application 30, such as screen color, etc.

[0056] Referring to FIG. 3, the parameters 56 can be used to monitor a login and application access request 110. This request 110 would query a Login Database 112, consisting of an Application Table 114 containing a handle Field that references the application 30, the application owner Field that holds which company actually has permission to use this application 30, and the application name Field which holds the actual name of the application 30. The database 112 also contains a Company Table 116 containing a list of all companies which have data accessible by a particular server 28, the companies handle for locating in other tables, and who the company owner is, represented by a handle Field for referencing the company for lookup, a comp owner Field for indicating who the owner of the company is, with respect to a Users Table 118, and a comp name Field which holds the actual name of the company. The Users table 118 contains a list of all users 18 who may log into the Application 30 running on the system 10, their passwords, their handle for locating in other tables, and what company the user 18 belongs to in the following fields, such as a handle Field that references the user 18 for lookup, a user password Field that holds the actual password for the user 18, a user company Field for referencing which company the user 18 belongs to via the company table 116, and a user name Field that holds the actual user name.

[0057] Accordingly, when a user 18 logs into the application 30, their password is checked on the server 28 under the login database 112 in the users table 118. The users table 118 contains a reference to the person's company, which is then used to see if the user 18 has permission to use that program 30, via the application owner field of the application table 114. For instance if Company A has this application 30, they don't want the user 18 in their rival Company B to be able to log into their own separate system 10. Further, the company table 116 in the login database 112 is also used to determine which security database 120 to use to get the application's 30 permissions.

[0058] For example, the security database 120 can include a Company Table 122 containing a list of all companies which access to the data 20 a,b by the selected server 28 a,b, their handle for locating in other tables, and who the company owner is, as described above with reference to table 116. The database 120 also includes an Entity Table 124 containing a list of all entities which exist for all applications 30 that have been initialized on the companies system 10. The entity table 124 contains a handle Field for referencing the entity for lookup by other tables in the database, an id Field that contains the actual id given to the entity, an application Field that distinguishes between entities that belong to different applications 30, so that entities can be identically named for completely different applications 30 with different security ratings, an owner Field that determines which user 18 may modify an entity's security settings, and a type Field that contains a reference to what type of object the entity is, be it an Application, Screen, Image, Grid, Field, etc.

[0059] The data base 120 also contains a Groups Table 126 that holds all available groups which may have security settings provided by entities, and contains a handle Field that references the group 126 for lookup by other tables in the database 120, a group name Field that holds the actual group name, a group owner Field that determines which user 18 may add or remove other users 18 from the group, or even delete the group, and a group application Field that determines which application 30 this group is for. The database 120 also has a Members Table 128, which sets the memberships for each group, based on the entries from users 134, groups 126 and application tables 114. The members table 128 contains a handle Field that references the member for lookup by other tables in the database 120, a mem group id Field that indicates what group the member belongs to, through groups table 126, a mem application id Field that indicates what application 30 this specific member entry is for, through the application table 114, and a mem user id Field that holds what the member's user id is through users table 134.

[0060] The database 120 also can have a Perm Ivars Table 130 that holds any customized user settings for the application 30 by references to a user ID Field that holds a reference to the user table's handle field to reference the proper user 18, a name Field that holds the name of the Permanent Ivar, and a value Field that holds the value the Ivar is to take on when the application 30 loads. The data base 120 also has a Permissions Table 132 that holds what permissions each entity has based on the application 30 and the group id by referencing a handle Field that references the group permission number for lookup by other tables in the database 120, an entity name Field that holds the entity name that these permissions are for, a per application id Field that holds which application 30 the entity belongs to, via the application table 114, a per group id Field that holds which group these permissions are for via the groups table 126, a permission add Field that holds whether or not the group has permission to add to the entity, True or False, a permission del Field that holds whether or not the group has permission to delete from the entity, True or False, a permission write Field that holds whether or not the group has permission to write to the entity, True or False, and a permission read Field that holds whether or not the group has permission to read from the entity, True or False. The database 120 can also have a Users Table 134, as described above with reference to table 118.

[0061] Accordingly, once the request 110 have caused the system 10, according to the application 30, to process the request 110 according to the databases 112, 120, the request 110 is either allowed with appropriate permissions 136, or is denied. If the request 110 is allowed, then the security settings come back from the respective server 28 according to the application 30 and the login message is sent to all corresponding entities of the application 30. Once a entity receives the login message, it checks it's security on creation and whenever the user 18 logs in. If an entity passes security, its visibility is set to true for the interface of the device 18, or otherwise false (invisible). The application security can be based on a particular entity, the group to which the current user 18 belongs to and the application 30. The final security for an entity is a union of all securities that fit the entity/group/application combination, as determined by the particular application 30 operating on the system 10 for a selected combination of components contained in the tiers 14, 16, 26 concerned.

[0062] Middle Tier Technology

[0063] The middle tier 26 technology of the system 10 can be provided in the central platform application 30 by use of the middle tier parameters 52. For example purposes, such as but not limited to, three middle tier 26 architectures can be supported by the central platform application 30 are Pass Through 24, EJB 28 a, and Component Object Model 28 b. Set up and implementation of the middle tier 26 components in the central platform application 30 can facilitate hiding details of running multiple transactions from users, as well as managing and pooling resources, to optimize system resources as well as scalability, reliability, and security.

[0064] The Component Object Model Architecture 28 b and associated operating platform 29 b helps devices 18 to make remote procedure calls and invoke services provided by COM-compliant components, whereby the COM standard of component interoperability and reusability enables software developers to build highly distributed systems by assembling reusable components from different software vendors. The COM standard also provides mechanisms for management of shared memory between components, whereby the devices 18 can request a COM object of a specified type. The COM implementations can pool COM objects and return these pooled objects to requesting devices, whereby when a device is finished using a particular requested object the instance it is returned to the pool. Accordingly, the parameters 52 concerning business logic and database queries can be expressed in the abstract notation of the file 30, such as XML format, to be used to generate COM objects that reside on the COM server 28 b. These COM objects can interact with other customized, client specific COM objects as required to meet client needs.

[0065] The parameters 52 can also be used to specify operational behavior of EJB server 28 a and associated platform file 29 a. EJBs are components written in the JAVA programming language, which can be run on any platform and operating system that supports the EJB standard, thereby facilitating the program designer to focus on the business logic of the application 30 and minimizing regard to server specific complications. Referring to FIG. 4, the client devices 18 communicate with the back-end of the architecture of the sever 28 a by using sockets and XML as the communication medium 138, which is directed to an intermediate level Java application 140. This application 140 interprets XML sent to it from the client level applications 18 into RMI calls 142 and forwards these on to the EJB server 28 a. Referring to FIG. 5, the EJB Server 28 a comprises entity beans 144 a,b and session beans 146. It should be noted that the entity beans 144 b has persistence managed by the bean, and the entity beans 144 a in which persistence is managed by the container. The bean 144 b itself is responsible for making JDBC calls to the database 20 a,b to implement necessary database functionality though the corresponding interface 21 a,b. The entity bean 144 a makes less complex calls to the container and the container takes care of low level details of database 20 a,b access. Accordingly, EJB servers 28 a can be programmed to handle underlying transaction management details. The system 12 can be programmed by the parameters 52 to generate EJBs 28 a from the abstract notation description of the application 30, thereby providing such middle tier 26 services as transactions, security, database connectivity, threading, and persistence.

[0066] Further parameters 52 can be used to implement platform independent techniques for call procedures to objects across diversely distributed systems, as well as the ability to pass through corporate firewalls in order to transmit data obtained or returned to the data sources 20 a, b. Accordingly, parameters 52 defining the Simply Object Access Protocol (SOAP) can be used to specify functions under the “request/response” message model. The parameters 52 can include information on Remote Procedure Calls (RPC), which can be serialized into SOAP messages defining the call parameters. A further parameter 52 can include information on the interpretation of SOAP messages by a server capable of remitting objects, as well as calls on a “session Object” to execute the actual procedure code to return the desired value. This value can be serialized into the SOAP message and then sent back to the client side, where it is then deserialized. Accordingly, the parameters 52 are used in the application 30 to help define the call procedures as well as the pass parameters used with the call procedures. Furthermore, SOAP messages containing error values (if the desired procedure is not successfully implemented) can also be included, so that the platforms 29 a, 29 b can be used to define structures to return requested values, as well as error values. These parameters help the systems of the middle tier 26 to become distributed and to facilitate the full accessibility of shared objects. Further parameters 52 can include instructions for transporting XML documents through HTTP, thereby providing for SOAP messages that are understood by application supporting the technologies of both HTTP and XML.

[0067] Implementation of the business logic on the middle tier 26 can be facilitated by the use of neurons and reports, as the system 12 is built upon a fully message-based architecture. Preferably the neurons can be implemented in the first tier 14. Visual elements on the client 18 such as buttons generate and respond to messages over the network 22 when users interact with them. Some examples of these messages for database 20 a,b interaction can include: a window closing when a user clicks the “close” button, a row being selected when a user clicks on a row of a grid, and an input box changing when a user enters a value and clicks the “change” button. This messaging system incorporated in the application 30 yields an event-driven architecture, which facilitates the development of behaviors in the applications 30. These messages are sent on distinct channels to the central server 28 a,b location, which coordinates the distribution of messages. The central system 28 a,b distributes the messages to every listener device 18 that is listening to the channel over the network 22 on which the message is being sent. Relaying all of an application's 30 messages to the central system 28 a,b facilitates the customization and interaction with the application's 30 behavior.

[0068] Certain applications 30 use “Neurons” for complicated behaviors, which are preferably implemented in the first tier 14 business logic. Neurons are an abstract concept that can be defined as something that receives, interprets, and sends messages for the system 10 over the network 22. In the case of implementation of neurons on the first tier 14, the neurons send messages within the platform 19 a, b, c, d of the devices 18 a, b, c, d. Neurons are programmatic in Extensible Markup Language (XML) but can be coded in Java for intricate and or user-specific behaviors, for insertion into the file 38 and/or generator 42 to produce the central application platform 30. Neurons permit the specification of arbitrary behaviors.

EXAMPLE XML

[0069] 01 <entity ID=“set_date_neuron” type=“Neuron”> 02 <param name=“in”> 03 <channel>WidgetStatus.comm</channel> 04 </param> 05 <param name=“middle”> 06 <waitfor> 07 <condition paramname=“action” >“loaded”</condition> 08 <condition paramname=“type” >“WidgetStatus”</condition> 09 <condition paramname=“id“ >“title_screen”</condition> 10 <create var=“date” /> 11 <getglobal var=“date” ivar=“.date”/> 12 <setglobal var=“.main.title_screen.grid.label.current_date”>$date 13 </setglobal> 14 <java> 15 insert java code into generated code here 16 </java> 17 </waitfor> 18 </param> 19 </entity>

[0070] The example XML above represents the neuron that acts to set a date within an application when executed. Neurons listen to specific channels over the network 22, or within platform 19 depending on the tier 14, 26 used, for the instruction to execute their body code. The Line 03 illustrates that this neuron is listening to the channel “WidgetStatus.comm.”. Any message sent across this channel will trigger this neuron to execute its body code. The body code of a neuron is encapsulated within “<waitfor>” tags (Lines 06 through 18). Before executing this body code, the neuron will check to ensure that certain conditions have been met. These conditions can be found on Lines 07 through 09. The first condition (Line 07) relates to the action that must have occurred to trigger this neuron. This condition will check to ensure that the neuron was triggered by an “action” of type “loaded”. Recalling that users on the client side trigger neurons, some other examples of “action” conditions include: a grid being “opened”, a button being “clicked”, or in this case, a screen being “loaded”.

[0071] The second condition (Line 08) relates to the type of message that triggers this neuron across the “WidgetStatus.comm.” channel. Line 08 specifies that the message must be of type “WidgetStatus”. The third condition (Line 09) relates to the origin of the message that triggers this neuron. This condition will check to ensure that the neuron was triggered by a “title_screen” widget. When all of the above conditions have been met, this neuron will create a variable called “date” (Line 10) and assign it the value stored in the Intelligent Variable (IVar) “.date”. IVar's are generally variables that hold data within widgets of an application. IVars such as “.date” and “.time” are unique IVars because they are derived from the system and not from widgets of an application. When executed, Line 11 will retrieve the current date from the system and assign this value to previously declared variable known as “date”. Line 12 makes use of an anchor to set a label widget within a screen of an application to display the current date. To accomplish this, the “date” variable that now stores the current date must replace an existing variable within the label widget. The existing variable within the label widget is accessed by the use of an anchor, which essentially acts as a hierarchal reference. This anchor in this particular example is “.main.title_screen.grid.label.current_date”. Accordingly, highly specialized behaviors can be implemented for highly customized software solutions 30 by inserting native Java code into the body of the neuron. Lines 14 through 16 demonstrate how we insert native Java Code into generated code. Choosing to do so, however, can remove platform independence.

[0072] A further construct to implement the business logic of the middle tier 26 are Reports, of which the functionality of Neurons is quite similar. The Reports of the application 30 facilitate presentable documentation with regards to data-centric software applications 30. Reports contain application server business logic. Reports are useful for data processing and global calculations. A report could be used to create, such as but not limited to, a balance sheet, income statement, or post transactions to a series of accounts. Reports are specified using a similar Document Type Definition (DTD) to that used by Neurons.

EXAMPLE XML

[0073] 01 <entity ID=“Example_Report” type=“Report”> 02 <param name=“name”>this is a report</param> 03 <param name=“code”> 04 <report> 05 <reportmain> 06 <body> 07 <center>this is an example report</center> 08 <create var=“p1”/> 09 <set var=“p1”>-1</set> 10 p1 = <get var=“p1” /> 11 <include file=“layout.xml”/> 12 ________________________________________________________ 13 <pp> 14 <image source=“. . ./image/ariussoftware.gif”/> 15 <item>Insert Data 1</item> 16 <item left=“10” top=“10”> 17 Insert Data 2 18 </item> 19 <item left=“10” top=“30” width=“10”> 20 Insert Data 3 21 </item> 22 <item left=“200” top=“40” height=“300”> 23 <image source=“. . ./image/custom_picture.gif”/> 24 </item> 25 </pp> 26 ________________________________________________________ 27 </body> 28 </reportmain> 29 </report> 30 </param> 31 </entity>

[0074] The example XML above represents Report entities are defined in the XML descriptions 38. Multiple reports that use similar layout and presentation properties can reference an external XML file to handle these similarities. This feature is displayed in Line 11. Line 07 illustrates one of the layout and presentation tags that are used in reports. The <center> tag is used to center align data. Lines 08 through 10 highlight our ability to use Intelligent Variables (IVars) in our reports. IVars can be used by queries to retrieve data from the database 20 a,b for the purpose of generating reports. Lines 14 and 23 highlight how images can be inserted into our reports to enhance the visual appeal. Line 13 contains the tag “<pp>”, which stands for Precise positioning. Business data can be inserted in Lines 17, 19, and 22. The <item> tags encapsulating these lines are used to define layout properties for precise positioning. Accordingly, as discussed above, Reports are written within file 38 under Report entity, under the param named“code”. Neurons are also written in the file 38 under the Neuron entity, but it does not have a param named“code”. Neurons and Reports share a lot of functionality between them. Reports are used to create visual pages, where Neurons are used to help with functionality.

[0075] Example components of reports can include:

[0076] <entity ID=“ReportId” type=“Report”>

[0077] <param name=“name”>Report Eg</param>

[0078] <param name=“width”>800</param>

[0079] <param name=“code”>

[0080] <report>

[0081] <reportmain>

[0082] <header>

[0083] <font size=“4”>Report Eg</font>

[0084] <break/>

[0085] </header>

[0086] <body>

[0087] <table border=“0”>

[0088] <row>

[0089] <cell>Cell1</cell>

[0090] <cell>Cell2</cell>

[0091] </row>

[0092] </table>

[0093] </body>

[0094] </reportmain>

[0095] </report>

[0096] </param>

[0097] </entity>

[0098] Explanations of the above components are:

[0099] Report

[0100] A tag for when dealing with a report entity under param named “code”.

[0101] Reportmain

[0102] Indicates the location of the main processing loop.

[0103] Include

[0104] This tag is used to read in data from a file. If the file exists, and its contents can be read, the contents of the file are outputted in place of the tag. The file attribute specifies the file to be included. The file must have the correct report syntax. E.g. <include file=“Name of File”/>

[0105] Header

[0106] This tag is used at the beginning of a report. The header text between the opening and closing tags is used to display the report title. Fonts and layout tags may be used as well in between the header tags.

[0107] Body

[0108] This tag is usually inserted after the header tag. The text between the opening and closing body tags will be the majority of the report. Almost everything you want displayed can go here.

[0109] Footer

[0110] This tag is much like the header or body, except this tag is used at the bottom of the report and will follow the closing body tag. Text between the opening and closing tags will be displayed at the bottom of the report. Font and layout tags may be used as well in between the footer tags.

[0111] E.g. <header>

[0112] . . . Display Header Info . . .

[0113] </header>

[0114] <body>

[0115] . . .

[0116] . . . . Body of Report . . .

[0117] . . .

[0118] </body>

[0119] <footer>

[0120] . . . Display Footer Info . . .

[0121] </footer>

[0122] Left, Center, Right

[0123] These tags are used to align whatever is in between the opening and closing tags. Alignment is relative to the page.

[0124] Bold, Italic, Underline

[0125] These tags will format whatever text is in between their opening and closing tags.

[0126] Table

[0127] This tag will define a table, much like that of an HTML table. The border attribute is assigned an interger that will define the thickness of the border. The width attribute is assigned an integer that will define the width of the table, as similarity the height attribute describes the height of the table.

[0128] Row

[0129] This tag belongs between the table tags. The row tag defines a single row in the table. For every set of opening and closing row tags, one row exists in the table. The tag has a height attribute that is assigned an integer.

[0130] Cell

[0131] This tag belongs between the row tags. The cell tag defines one cell in the table. If there were twenty opening and closing cell tags between any row tags, then the table would have twenty columns. This tag has a width attribute that is assigned an integer.

[0132] Font

[0133] The font tag is used on text. Whatever text is between the opening and closing font tags will be affected. The font attributes are name—font name, size—size of font, and color—color of font.

[0134] Image

[0135] This tag allows the insertion of images into Reports. It has a source attribute, which is assigned a string containing the location of the image. Width and height attributes both take on integers describing the width and height of the image.

[0136] Margin

[0137] This tag allows us to set margins for the Header, Body, and Footer. The tag must be contained in the desired section or sections. Margin tags have attributes left, right, top, and bottom, which set distance from the sides of the page.

[0138] Break

[0139] This tag will simply move to a new line in the Report.

[0140] PP

[0141] This ‘precise positioning’ tag will define an area where items will be inserted. Width and height attributes describe the width and height of the area.

[0142] Item

[0143] These tags are used between the opening and closing pp tags. Item tags are used to surround text, images, etc. Attributes xloc and yloc describe the location of an item relative to the top left corner of the pp tag. Width and height are used as well to describe the width and height for the item. At runtime, if width or height of an item has gone over the pp tag's boundaries, the pp tag will expand to fit all the items.

[0144] There can be tags that are common to both Neurons and Reports, such as:

[0145] Funcdef

[0146] This tag requires attribute name which is the name of the function. Optional attributes type, used when the function has a return type, and var, the name of the variable that is returned in the function, are also available to use.

[0147] E.g. <funcdef name=“hello”>

[0148] <paramdef name=“p1”/>

[0149] <paramdef name—“p2”/>

[0150] <code>

[0151] <if>‘$p1’ eq ‘1’</if>

[0152] . . .

[0153] <elseif>‘$p2’ eq ‘−1’</elseif>

[0154] . . .

[0155] <else/>

[0156] <if>true</if>

[0157] . . .

[0158] <endif/>

[0159] . . .

[0160] <endif/>

[0161] </code>

[0162] </funcdef>

[0163] Paramdef

[0164] Paramdef is used to define arguments for defined methods. Name, the name of the parameter, is the required attribute of this tag. An optional tag, type, is also used to define the parameter type. See the above example.

[0165] Funcuse

[0166] This tag is used to call a defined function. The name attribute is specified with the name of the defined function. An optional attribute, var, can equal the name of a variable that will take on the result of the function. E.g. Assume a function add is defined:

[0167] <create result/>

[0168] <funcuse name=“add” var=“result”>

[0169] <paramuse name=“p1”>25</param>

[0170] <paramuse name=“p2”>10</param>

[0171] </funcuse>

[0172] The value in variable result will be 35.

[0173] Paramuse

[0174] This tag is used in conjucntion with the Funcuse tag to pass in arguments for a function. The attribute name specifies the paramter of the function. Take a look at the above example.

[0175] Java

[0176] Java code in between these two tags gets dropped directly into the generated code.

[0177] For

[0178] This tag is used to create a loop. It requires attributes var, start, end, inc, and compare to be set within the opening tag. Var can be set equal to the name of a variable, otherwise a variable with that name will be created. Var will be set to the value of start, so that each time through the loop, all statements between the opening and closing tags will execute, and var will be incremented by inc. This will continue until the value of var, compare, and end evaluates to false, where compare is an operator (see Conditional/Control Tags).

[0179] E.g. <for var=“Var” start=“Number” end=“Num” inc=“Num” compare=“Oper”>

[0180] . . . (Statements) . . .

[0181] </for>

[0182] Squery

[0183] This tag is used to load an squery. The qname attribute defines the query name that is to be loaded.

[0184] E.g. <squery qname=“Name”/>

[0185] Numcols

[0186] This tag is used to return the number of columns in an squery. Query name attribute qname, name of the query, and variable attribute var, name of the variable used to store the number of columns, must be specified within the tag.

[0187] E.g. <numcols qname=“Name” var=“Variable”/>

[0188] Numrows

[0189] This tag is used to return the number of rows in an squery. Query name attribute qname, name of the query, and variable attribute var, name of the variable used to store the number of rows, is be specified within the tag.

[0190] E.g. <numrows qname=“Name” var=“Variable”/>

[0191] Setrow

[0192] This tag is used to set the current row index in an squery. Query name attribute qname, and row attribute row is specified within the tag.

[0193] E.g. <setrow qname=“Name” row=“Number”/>

[0194] Getrow

[0195] This tag is used to return a row from an squery. Query name attribute qname, and variable attribute var, which holds the returned value, is specified within the tag.

[0196] E.g. <getrow qname=“Name” var=“Variable”/>

[0197] Setcell

[0198] This tag is used to set the value of the indexed cell. Query name attribute qname specifies the query name, rowindex attribute specifies the row number, colindex specifies the column number, and value attribute value is the value to which you want to set the cell.

[0199] E.g. <setcell qname=“Name” rowindex=“Number” colindex=“Number” value=“Val”/>

[0200] Getcell

[0201] This tag is used to get the value of an indexed cell. Query name attribute qname specifies the query name, rowindex attribute is used to specify the row number, colindex specifies the column number, and variable attribute var is the variable that the result will be put into.

[0202] E.g. <getcell qname=“Name” rowindex=“Number” colindex=“Number” var=“Var”/>

[0203] Deleterow

[0204] This tag is used to delete a row from an squery result set. Query name attribute qname, and row attribute row is specified.

[0205] E.g. <deleterow qname=“Name” row=“Number”/>

[0206] Addrow

[0207] This tag is used to add a blank row to an squery. Query name qname is specified within the tag.

[0208] E.g. <addrow qname=“Name”/>

[0209] Sqsave

[0210] This tag is used to save an squery result set back to the database. Query name attribute qname is specified within the tag.

[0211] E.g. <sqsave qname=“Name”/>

[0212] Create

[0213] This tag is used to create a variable. Within this tag, attribute var is followed by the variable name.

[0214] E.g. <create var=“VariableName”/>

[0215] Set

[0216] This tag is used to set the value of a variable. Within this tag, attribute var is followed by the variable name. After closing the tag, follow it by the value for the variable. Note that a variable must be created before it can be set.

[0217] E.g. <set var=“Age”>23</set>

[0218] The above will set variable age to 23.

[0219] Get

[0220] This tag is used to get the value of a variable. Within this tag there is the attribute var followed by the variable name.

[0221] E.g. <create var=“temp”/>

[0222] <set var=“temp”>Hello World!</set>

[0223] temp=<get var=“temp”/>

[0224] The above should print out: temp=Hello World!

[0225] Initglobal

[0226] This tag is used to initialize a global variable. Within this tag there is the attribute var followed by the variable name.

[0227] E.g. <initglobal var=“GlobalVarName”/>

[0228] Setglobal

[0229] This tag is used to set the value of a global variable. Within this tag there is the attribute var followed by the variable name. Then close the tag and follow it by the value for the global variable. Note that a global variable is initialized before it can be set.

[0230] E.g. <setglobal var=“GlobalVarName”>Value</setglobal>

[0231] Getglobal

[0232] This tag is used to get the value of a global variable and set a local variable to the result. Note to reference global varibles you load them into a local variable. Within this tag there is the attribute var followed by the local variable name and there is the attribute ivar followed by the global variable name.

[0233] E.g. <create var=“TempLocalVar”/>

[0234] <getglobal var=“TempLocalVar” ivar=“GlobalVarName”/>

[0235] Example components of Neurons for first tier 14 or middle tier 26 can be:

[0236] <entity ID=“sample_test_neuron” type=“Neuron”>

[0237] <param name=“in”>

[0238] <channel>channelA</channel>

[0239] </param>

[0240] <param name=“middle”>

[0241] <waitfor>

[0242] <condition paramname=“mesgName”>“Example”</condition>

[0243] <message mesgname=“Name” type=“Widget” channel=“channelName”></message>

[0244] <setmessageparam mesgname=“Name” param=“colour”>“blue”</setmessageparam>

[0245] <send message=“Name”/>

[0246] </waitfor>

[0247] </param>

[0248] </entity>

[0249] Explanations of the above components are:

[0250] Sum

[0251] This tag will enable you to find the sum of a specified column in an squery. The attribute query is the name of the squery, the attribute table is the table name of the the column you would like to use, and of course the field is the name of the column to use.

[0252] E.g. <sum query=“queryName” table=“tableName” field=“fieldName”/>

[0253] Avg

[0254] This tag will enable you to find the avgerage of a specified column in an squery. The attribute query is the name of the squery, the attribute table is the table name of the column you would like to use, and of course the field is the name of the column to use.

[0255] E.g. <avg query=“queryName” table=“tableName” field=“fieldName”/>

[0256] Createmessage

[0257] These tags reside under the param named “middle” in a neuron entity. This tag will create a message that the neuron can later send on the specified channel. The attribute type is used to specify the type of message. The possible values for type are described under the Messaging System section. The msgname attribute is an textual name you may assign the message. The final two attributes specify which channel to send the message, but they differ slightly in functionality and only one of the two attributes must be specified. The channel attribute specifies what channel you want to send the message on, and when the message is sent it is sent to everone listening on that channel. The relative channel attribute differs slightly in that it will still send the massage on the specified channel, but only from a certain height in the tree. So, if we had two instances of a screen, this allows us to send messages only to other widgets on the same instance of a screen and not to both.

[0258] E.g. <entity ID=“neuron_id” type=“Neuron”>

[0259] . . .

[0260] <param name=“middle”>

[0261] <createmessage type=“messageType” msgname=“messageA” channel=“channelX”/>

[0262] <createmessage type=“messageType” msgname=“messageB” relativechannel=“parent.channelX”

[0263] </param>

[0264] . . .

[0265] </entity>

[0266] Channel

[0267] These tags reside under the param named “in” in a neuron entity. The purpose of the channel tags is to specify which channels the neuron is to listen on. The name of the channel goes between the opening and closing channel tags.

[0268] E.g. <entity ID=“neuron_id” type=“Neuron”>

[0269] <param name=“in”>

[0270] <channel>channelA</channel>

[0271] <channel>channelB</channel>

[0272] </param>

[0273] . . .

[0274] </entity>

[0275] Setmessageparam

[0276] These tags reside under the param named “middle” in a neuron entity. This tag allows you to add any user defined parameters to a message. The mesg-name attribute specifies the message that we are adding a parameter to. The param attribute specifies the name of the created parameter. The value of the parameter is enclosed between the opening and closing tags and between double quotes.

[0277] Send

[0278] These tags reside under the param named “middle” in a neuron entity. It sends a specified message using the message attribute to specify a message name.

[0279] E.g. <entity ID=“neuron_id” type=“Neuron”>

[0280] . . .

[0281] <param name=“middle”>

[0282] <createmessage type=“messageType” msgname=“messageA” channel=“channelX”/>

[0283] <setinessageparam mesgname=“messageA” param=“colour”>“blue”</setmessageparam>

[0284] <send message=“messageA”/>

[0285] </param>

[0286] . . .

[0287] </entity>

[0288] Getmessage

[0289] These tags reside under the param named “middle” in a neuron entity. The getmessage tag takes the message that fired the neuron and creates a specified variable that it is put into. The mesgname attribute is the name of the variable to be created and for the message to be inserted into. The creation of this variable will then allow the user to read message information.

[0290] Getmessageparam

[0291] These tags reside under the param named “middle” in a neuron entity. The getmessageparam tag will read a specified parameter from a specified message and create a given variable and insert the parameter value into the created variable. The var attribute is the name of the varibale to be created and store the result. The mesgname attribute is the name of the message to be used. And the param attribute is the paramter name that we are interested in.

[0292] E.g. <entity ID=“neuron_id” type=“Neuron”>

[0293] . . .

[0294] <param name=“middle”>

[0295] <getmessage mesgname=“messageVar”/>

[0296] <getmessageparam var=“paramValue” mesgname=“messageVar” param=“colour”/>

[0297] </param>

[0298] . . .

[0299] </entity>

[0300] Condition

[0301] These tags reside in two places. They may reside between the waitfor tags or they may be between the seekmessage tags. These tags simpply specify a condition on message parameters. The paramname attribute defines the name of the parameter that we want to test. Between the opening and closing tags, surrounded by double quotations, will be the desired value of the parameter. The attribute op may also be included an operator to help with a range. There is one extra operator for the condition tags which is ambig. This is used to compare widget names to general cases. So any instance of that widget will evaluate to true.

[0302] E.g. <condition paramname=“colour”>“blue”</condition>

[0303] <condition paramname=“age” op=“lte”>“23 “</condition>

[0304] <condition paramname=“windowName” op=“ambig”>”.main.a_screen.b_grid”</condition>

[0305] <!—so in this last condition .main#1.a_screen#3.b_grid#7 will evaluate to true,

[0306] but something like .main# 1.a_screen#5.c_screen#3 will evaluate to false—>

[0307] Waitfor

[0308] These tags reside under the param named “middle” in a neuron entity. The opening and closing tags form a block of code that will be executed when certain conditions are met. The opening tag is followed by a set of conditions that have to be met before it can then proceed with the rest of the code contained within the waitfor tags. Every set of waitfor tags are executed sequentially. So if we are currently at the first waitfor tag and the conditions are met for the second waitfor tag, then only the code outside all of the waitfor tags will be executed. Otherwise if the message that fired the neuron meets the conditions of the first waitfor tags and the neuron has not yet executed the code between the first waitfor tags, then it will do so. Note that the condition tags are optional. If no condition tags are specified then when a message fires the neuron then the code within the waitfor tags will be executed since there is no conditions to test.

[0309] E.g. <entity ID=“neuron_id” type=“Neuron”>

[0310] . . .

[0311] <param name=“middle”>

[0312] <waitfor>

[0313] <condition paramname=“colour”>“blue”</condition>

[0314] . . . (Statements). . .

[0315] </waitfor>

[0316] <waitfor>

[0317] . . . (Statements) . . .

[0318] </waitfor>

[0319] </param>

[0320] . . .

[0321] </entitiy>

[0322] Pushmessage

[0323] These tags reside under the param named “middle” in a neuron entity. Neurons each provide their own individual statck where messages may be stored for future uses. The attribute mesgname is the name of the message that you want to push onto the statck. Note that you must first use the ‘getmessage’ tag before pushing a message.

[0324] Popmessage

[0325] These tags reside under the param named “middle” in a neuron entity. This tag allows us to pop a message off the top of the stack into a specified variable. The attribute mesgname is the name of the variable that will be created as well as hold the message that was poped off the top of the stack.

[0326] Seekmessage

[0327] These tags reside under the param named “middle” in a neuron entity. This tag will allow us to find a message in the stack based on a number of conditions. The attribute var is the name of variable that the result will be assigned to. If a message is found based on the conditions then the index in the stack will be assigned to the specifed variable. If nothing is found then −1 is assigned to the variable. Note that only the first message that satisfies the conditions is returned. The conditions must be inside the opening and closing tags of seekmessage.

[0328] Peekmessage

[0329] These tags reside under the param named “middle” in a neuron entity. This tag will allow us to retrieve a message out of the middle of the stack. Given an index in the stack we may retrieve the message into a new variable that we also specify. The attribute var is the index on the stack where the message we want resides. The attribute mesgname will be the newly created variable that will hold the retireved message.

[0330] Dropmessage

[0331] These tags reside under the param named “middle” in a neuron entity. This tag will allow us to remove a message from the middle of the stack. Given an index in the stack we may remove that message. The attribute var is the index on the stack where the message we want to drop resides.

[0332] E.g. <entity ID=“neuron_id” type=“Neuron”>

[0333] . . .

[0334] <param name=“middle”>

[0335] <getmessage mesgname=“messageVar”/><!—get the message that fired us—>

[0336] <pushmessage mesgname=“messageVar”/><!—push it onto the stack—>

[0337] . . .

[0338] <create var=“index”/>

[0339] <seekmessage var=“index”>

[0340] <condition paramname=“colour”>“blue”</condition>

[0341] </seekmessage>

[0342] <!—index should contain the index on

[0343] the stack if the message was found

[0344] with a parameter colour-blue—>

[0345] <peekmessage var=“index” mesgname=“foundMessage”/>

[0346] <!—foundMessage should contain the actual message—>

[0347] <dropmessage var=“index”/>

[0348] <!—the message previously found is

[0349] removed from the stack—>

[0350] </param>

[0351] . . .

[0352] </entity>

[0353] Accordingly, the implementation of business logic including Neurons in the first tier 14 and Reports in the middle tier 26 can be programmed by the software designer for inclusion with the parameters 40, 44.

[0354] Abstract Based Declarations

[0355] Referring to FIG. 2, the development system 12 also uses input parameters 40 to help generate the abstract application description file 38, from which the central platform application 30 is generated. The descriptions 38 can be store in platform independent format. The file 38 is preferably written in an abstract notation such as XML, which makes use of structure tags to describe the data contained in the file 38. In particular, HTML can also be used as an abstract language with standard tags, however the XML format also provides capability of defining tag names to further accurately describe the data contained in the file 38. Accordingly, the file 38 contains descriptions of applications written in the abstract notation language, XML, whereby every element of the application 30 is represented by an entity that is described in the file 38. These entities in general can represent a visual, behavioral, and data aspects of the application 30.

[0356] The visual entities can include screens, buttons, and images. Behavioral entities can involve neurons. Data entries can include records, fields, and queries. As discussed below, the entities can be defined by the respective type, parameters, children, and are referenced by their ID. The entities in the application 30 can have parent child relationships, which determine the overall structure of the application 30. Accordingly, the file 38 once assembled is a declaration of all the various components which can be found in the application 30, such as but not limited to grids, records, screens, database queries, and database tables. These components are then related to one another by a series of parent/child relationships which facilitate the components to be reused (i.e. having multiple parents). A sample code listed below is used to illustrate the relationships that can exist between entities and to exemplify the usage of the XML format to provide the files 38: <entity ID=“batch_trans” type=“Screen”> 02 <param name=“name”>Transactions</param> 03 <child name=“batch_trans_grid”> 04 <param name=“row”>1</param> 05 <param name=“column”>0</param> 06 <param name=“rowspan”>1</param> 07 <param name=“columnspan”>1</param> 08 <param name=“anchor”>NORTH</param> 09 <param name=“fill”>BOTH</param> 10 <param name=“ivars”>batch_grid.rowid = parent.parent, squery = parent.parent.batch_grid</param> 11 </child> 12 <child name=“transactions”> 13 <param name=“row”>0</param> 14 <param name=“column”>0</param> 15 <param name=“rowspan”>1</param> 16 <param name=“columnspan”>1</param> 17 <param name=“anchor”>CENTER</param> 18 <param name=“fill”>BOTH</param> 19 </child> 20 </entity> 21 <entity ID=“batch_trans_grid” type=“Grid”> 22 <param name=“name”>Transactions</param> 23 <child name=“batch_trans_query”> 24 </child> 25 </entity> 26 <entity ID=“transactions” type=“Image”> 27 <param name=“name”>Transactions Title</param> 28 <param name=“image”>image/transactionstitle.gif</param> 29 </entity>

[0357] Accordingly, line 1 of the sample code begins with the definition of the entity within the application 30. The entities type is declared near the end of line 1, which provides a “screen” which describes the screen within the application 30 to be generated. Line 3 is the first occurrence of the parent child relationship that exists between the entities, which for this example “batch_trans_grid” is being defined as the child of “batch_trans”, which is now regarded as a parent. Each child entity can have its own separate definition, which is not included in the definitions of their respective parents. Further examination of the above example code shows that line 3 references line 21 to define “batch_trans_grid”. Accordingly, lines 4 through 9 are lines of code that are specific to the layout system of the application 30 and describe how the “batch_trans_grid” entity will be visually represented in the graphical user interface 58 (see FIG. 6) displayed on the device 18 by the application 30. Line 10 describes an Intelligent Variable (IVAR), which links the behaviors of the entities concerned.

[0358] Applications 30 that are considerably high in complexity generally involve an elaborate data structure, representing the intricate parent child relationships between the entities. Accordingly, referring to FIG. 6, which is the example interface 58 for the device 18, has been generated as a result of the above presented XML code of lines 1 to 29. The interface 58 shows a series of widgets 60 a, b, c or display elements, which are elements of the application 30 represented by the entities in the above sample XML code. The variety of widgets 60 can be categorized into three main groups, visual 60 b, interactive 60 c, and data access widgets 60 a. The visual widgets 60 b can include labels, images, screens, and tabs. Interactive widgets 60 c can include buttons, clickable images, and input boxes. Data access widgets 60 a can include grids, records, and reports. Accordingly, it should be noted that the above XML code description of the sample user interface 58 contains a series of platform independent widgets 60 a,b,c that are represented by the entities contained in the file 38, through which the program generator 42 can use to generate the application 30 on a variety of platforms, which are dependent upon the type of parameters 50, 52, 54 that are specified by the program designer.

[0359] Referring to FIG. 7, in order to support legacy data sources 20 a, b you can create custom tables 150 and custom reports, by providing custom declaration 148 in the file 38.

[0360] Custom reports trigger a transaction like behavior such as purging old data in the databases 20 a, b. They are constructed involving procedural method which returns a string of XML to be displayed.

[0361] Custom tables 150 are specified on a row level as many legacy applications are row oriented. Each row object needs to support seven simple operations:

[0362] The first six methods can perform their function as specified, the seventh function can be defined but can be left empty. If the function is left empty no logging is supported on the custom table 150. Logging is used to synchronize various clients 18 without reloading all of their data. Assuming one user 18 makes a change and the other 18 wishes to update they could simply query the log for the changes made. If logging is not supported then they can reload all of the data.

[0363] Custom reports and tables 150 can be defined in two languages C# or Java. If defined in Java they can be used by either the passthrough system 24 or the EJB server 26. If defined in C# then they can be used in the COM 28 b system.

[0364] The loadData( ) gets all the non-standard data from the datasource 20 a,b and returns it in the Table-Data, which is more or less a wrapper for a Vector of StringVectors, each of which is a row in the table. The StringVector is a wrapper class created to lower the amount of excessive casting when using a Vector of Strings. The loadMetaData( ) gets the field information and returns it in a TableDef, which contains a vector of FieldDefs. Each FieldDef contains information about a field such as its name, default value, and names of any queries that generate its pull-down menus in the case of a field that contains integers, which refer to the handle fields of other tables. The save( ), saves changes to the data source 20 a,b. Changes are stored within CustomTableBase 154 in a Vector of TableChange objects. TableChange extends Vector and contains RowChange objects, each of which describes a single change to the data. Revision numbers can be used to inhibit conflicting data from reaching the data sources 20 a,b and to facilitate optimization and sort TableChanges.

[0365] Furthermore, there are three integer fields 156, 158, 160 in the CustomTableBase 154. The loadedStatus 156 stores the revision number the table 162 was at when loaded. The lastCheckedStatus 158 is used with the sync( ) method, whereby sync( ) asks the data source 20 a,b for changes made to it since lastCheckedStatus 158 and sets lastCheckedStatus 158 to the current revision number of the table 162. The sync( ) helps in the PassThru Query System when more than one client 18 is able to access the data source 20 a,b simultaneously. However, if there is only one client 18, then it is anticipated that the data source 20 a,b is in sync with that client 18. Under EJB 28 a, it is possible that multiple users 18 can use the table 162 simultaneously, but preferably only one instance of the table 162 will exist at one time and therefore the table 162 would be in sync with the database 20 a,b. The currentStatus 160 represents the status the CustomTable 154 contains. This value 160 can be incremented whenever the table 162 is updated by the user, but may make no assumptions about the state of the data source 20 a,b. The tableUpdate vector stores the TableChange for the changes made at revision foo at location (foo-loadedStatus-1).

[0366] It should be noted that save( ) and sync( ) facilitate consistent pointer usage within the Custom Queries 148 of the application 30. It should also be noted that for tables 162 associated with SQL Databases 20 a,b exclusively, appropriate table access routines may already be included in the DBTable EJB 28 a family and accordingly custom queries 148 may not be needed.

[0367] Application Editor

[0368] Referring to FIGS. 8a, b, c, d, e, f the application editor interface 62 can be executed on an appropriate computer by the program designer to edit all desired features to be contained in the file 38. The editor 62 facilitates the modification of application entities 66 and their relationships 70, as well as to preview how the applications interface would look as accessed by the devices 18. Accordingly, the application editor 62 allows for the entry of declarations for the application file 38. The editor 62 contains a graph button 64, which allows the program designer to see the relationships 70 between all of the graphically presented entities 66 in a graphical manner in window 68. The presented graph in window 68 is a series of the entities 66 which are connected by directed lines 70. The application editor 62 also contains an entities button 72 which opens a window 74 containing grids that allow modification of the entities 66 in the program 38. The window 74 allows the program designer to modify the properties of the entity 66, add new entities 66, change entity types, and modify the relationships 70 and organization parameters for child nodes. The relations button 76 of the editor 62 can open an additional window 78 containing parent handle drop down lists 80, a child handle drop down list 82, a scroll bar 83 to go through the various entities 84 as shown in window 74, and an additional button 86 to create new relationships 70, as well as a delete button 88 to delete relationship 70 and a grid 90 to display parameter values of selected parent entities 66. The application editor 62 also contains a preview button 92 to allow the program designer to review the various entities 66 already incorporated into the application file 38, thereby providing a sample preview interface resulting from the entities entered thus far in the file 38 which will eventually be generated by the compiled version of file 38, i.e. central platform application 30, for display on the devices 18, such as the interface 58 shown in FIG. 3. FIG. 8f shows a sample interface 18 of the editor 46 from FIGS. 8a, b, c, d, e.

[0369] The entity section 74 contains all the entities 66 entered thus far in the application file 38, whereby new entities 66 can be added by entering the new entities ID, changing of an entity type by entering the new type, and changing an existing entity 66 ID, as well as browsing all the entities 66 contained in the file 38 thus far. The section 74 contains the parameters for the entity 66 currently selected, whereby the parameter values can be modified by clicking on the parameter value and changing as necessary. The section 74 contains a list of all the children for the parent entity 66 currently selected. Accordingly, the section 74 can be used to add a child node 66 by clicking in the child handle column and selecting the entity you would like to include as the child node. The section 74 contains all of the valid parameter names and their values for the child node 66 currently selected, whereby these parameter values and names can be changed by clicking on the Parma value field and modifying the value contained therein as required.

[0370] Referring to FIG. 9, when a widget 60 is added to the screen 58 the location must be specified, such as by using a number of cells 164. For example, the upper left cell 164 of the interface 58 can be referenced by (0,0). Accordingly, when adding a child entity to the screen 58 to be represented by the corresponding widget 60, its displayed location can be defined by indicating row and column numbers. Furthermore, other layout options are also available, such as columnspan, rowspan, fill, and anchor. Columnspan and rowspan attributes specify the number of columns or rows the widget 60 will span in a particular cell 164 or group of cells 164. The fill attribute specifies how the widget 60 itself should fill its corresponding cell 164. Possible values for the fill attribute are NONE, HORIZONTAL, VERTICAL, or BOTH. The anchor attribute may take on nine different values specifying a location inside the cell 164, such as NORTHWEST, NORTH, NORTHEAST, WEST, CENTER, EAST, SOUTHWEST, SOUTH, and SOUTHEAST, as shown in FIG. 9b. The following code represents the example widget 60 placement shown in FIG. 9a:

[0371] widget1: row=0 column=0 anchor=NORTHWEST

[0372] widget2: row=0 column=1 rowspan=2 fill=HORIZONTAL anchor=WEST

[0373] widget3: row=1 column=0 fill=VERTICAL anchor=NORTHEAST

[0374] widget4: row=2 column=0 columnspan=2 fill=BOTH

[0375] As defined above, widget2 expanded horizontally to fill available space, so the anchor value could as well have been CENTER or EAST. Widget3 expanded vertically to fill available space, so the anchor value could as well have been EAST or SOUTHEAST. Furthermore, in the event that no cell location is specified for the widget 60, the widget 60 would be added to the bottom of the cell 164 spanning across the entire row. In addition, widgets 60 are added to the bottom in the same order as originally created by the application 30. This can facilitate the addition of widgets 60 to the bottom of the screen 58. Furthermore, for non-viewable widgets, there is usually no point in specifying a location on the cell 164. Accordingly, widgets can be added to the screen 58 without having to specify a particular location.

[0376] The connections 70 between the entities 66 (see FIG. 8) provides a set of “entities” 66 in the application 30 connected to each other by a set of relationships 70 in a rather hierarchical fashion, even though some entities 66 have more than one parent 66. On the interface 58, many of the entities 66 turn into visible objects the user of the device 18 can see, such as but not limited to Grid, Graph, Navigator, and Screen. Other entities 66 may never be visible as widgets 60, such as but not limited to Publish, and Query. Accordingly, referring to FIG. 10, a relationships table 166 of the application 30 can monitor which entities 66 appear inside of other entities 66 on an interface screen 168 of the device 18. For example, which Tabs 170 are in the Screen 168 or which Fields 172 are in a Table 174, as displayed by the representative widgets 168, 170, 174. However, other kinds of relationships 70 may not get separate tables in the metadata database 20 a,b. For example, a current selection in a Navigator 176 might change the currently displayed row or record 178 in the Table 174, or move the selection in a Grid. It might also affect the Query object that controls Grid contents, like in an accounting application, so the Grid shows all transactions 178 attached to the currently selected account in the Navigator 176. Accordingly, the construct that entities 66 use to communicate with each other in the application 30 can be an Ivar or ivar 180.

[0377] The “I” in Ivar 180 stands for Intelligent, as in Intelligent Variables. Ivars 180 are used to connect 70 various entities 66 and permit them to work together intelligently. For instance, the Navigator widget 176 could choose which row of the database appears in a Record widget 178, or how to link a where clause of a Squery up to the value in an Input Field. In addition, not specifying full pathnames when targeting an entity 66 for connection 70 to other respective entities 66 can be accomplished by matching ivars 180. For example, if a Navigator N in the Tab X of screen B, which is a child of screen A, is to control the grid G right beside it in Tab X, it may not be necessary to point the navigator at A.B.X.G for functionability. Instead, an input such as wid=parent.parent.G, would specify where the grid is in relation to the navigator. More complex situations, for example, might have a screen called Transactions that contains a Grid G which lists the current set of transactions. The Transactions screen is a child of the Accounts screen, which has a grid AG. Selection of an account in AG and clicking the button would result in the Transactions screen popping up with a list of the various transactions that were done on that account. In using Ivars 180, this could be accomplished by referring the squery in the Transactions.G grid to parent.parent.AG, which would find the appropriate AG. This is in comparison to specifying the full path A.B.Accounts.AG. Accordingly, the queries (functionality) need not be changed in response to a rearrangement of the layout (formatting). Furthermore, the ivars 180 facilitate the reuse of the grids AG and G in different screens and different arrangements, in which they will be able to find each other through the specification of selected ivar matching. Ivars 180 can make the entities 66 reusable.

[0378] Again referring to FIG. 10, in specification of the entity 176 that publishes the ivar 180 a, the ivar 180 a can be linked to an ivar 180 b published by the other entity 178, perhaps one on the same screen 168. Accordingly, the Navigator 176 and the Record 178 on the same screen 168 can be linked by their ‘rowid’ ivars 180 a,b respectively. This linking can be done by specifying a matchlist 181 on one or both of the entities 177,178 recorded in the table 166 of the file 38. For example, the screen 168 with ID ‘exampscreen’ with two children; the Navigator 176 with ID ‘nav-one’ and the Record 178 with ID ‘rec-two’ is recorded in the table 166. Each of the children 176, 178 exports the respective ivar 180 a,b called ‘rowid’. The two 180 a,b by placing the following code in the nav-one entity of Table 166:

[0379] <param name=“IVars”>rowid=parent.rec-two.rowid </param>.

[0380] Accordingly, in the run-time application platform 30, the entity .main#1.exampscreen#5.nav-one#12 with matchlist 181 ‘rowid=parent.rec-two.rowid’ would link main#1.exampscreen#5.nav-one#12.rowed to match the ivar .main#1.exampscreen#5.rec-two#12.rowid. It should be noted that the ‘rowid=’ part of the matchlist 181 refers to the ivar 180 a named ‘rowid’ in the nav-one en-tity. The ‘parent’ in the matchlist 181 is used to go up the respective hierarchy by one level. Furthermore, multiple parent tags could also be implemented in a more complex hierarchy, as in ‘rowid=parent.parent.otherscreen.othemav.rowid’. In addition, it is possible to have multiple entities that all match a given ivar matchlist 181. If this occurs, the ivar 180 will link up with ALL matching ivars 180, which would have the effect of linking the ivars 180 of two widgets 60 previously separated. It is also possible to specify multiple matches in the same matchlist 181 for one entity 66, by separating them with commas: <param name=“IVars”>rowid=parent.rec-two.rowid, rowid=parent.parent.grid.rowid, datafield=childname.rowid </param>. It should be noted that the ivar matchlist 181 can use relative paths or absolute paths.

[0381] In the XML language notation of file 38, the Ivars 180 can be created by calling initlvar(String name, String matchlist). The name is the fully qualified name of the ivar 180, and matchlist 181 is the matchlist of the entity 66 publishing the respective ivar 180. Initlvar is usually called in an entity constructor. Ivars 180 can be set with setIVar or get their values with getIVar. In addition, in the event that your ivar 180 gets changed by another device 18, the corresponding widget 60 implements a IvarReceiver to register as a listener, thereby receiving notification of the change. Preferably, all the links 70 are bi-directional and independent of creation order. Types of ivars 180 can include Temporary Ivars which are associated with a particular device 18 session. The device 18 can set the temporary ivar, like setting a variable, which is then available for the device 18 throughout for the session. Accordingly, when the device 18 logs out or times out, the temporary ivars the device 18 created are destroyed. Permanent Ivars are associated with a database 20 a,b. When a permanent ivar is set, it is stored in the database 20 a,b, thus it is not destroyed when the device 18 logs out or times out (i.e. it is persistent. Server Ivars cannot be set by the device 18, rather they can only be retrieved.

Example Entities and Relationships

[0382] The application 30 is built out of entities 66—objects such as grids, tables, groups, queries, and screens, which are combined by relationships 70. For example, a screen with a table and a grid in it. Each relationship 70 consists of a “parent” and a “child” entity 66.

[0383] For entity 66 naming, as the generated application 30 runs, it creates various screens, which contain widgets 60 and other screens, generating a hierarchy of widgets 60. Each of these widgets 60 must have a unique name in order to be unambiguously referenced. Each entity 66 in the file 38 has a unique ID, but lacks the ability to specify names for objects in a run-time system 10. We could have multiple instantiations of a single entity 66 and those instances could occur in different locations on the hierarchy of entities 66. Run-time entities 66, thus, are assigned unique names that can look something like: .main#1.subscreen#5.samplegrid#12. The name of the widget 60 is preferably determined by taking its ID, adding ‘#’ and a unique number, then appending that to the name of its parent. This facilitates determination at a glance both the entity 66 ID and ancestry of a run-time object. The name .main#1.subscreen#5.samplegrid#12 can be broken down into the main application 30 entity 66 with ID ‘main’ and run-time name .main#1. It has a child which is a screen, with ID ‘subscreen’ and run-time name main# 1.subscreen#5, and itself has the grid with ID ‘samplegrid’ as a child.

[0384] In regards to Ivar 180 naming, many widgets 60 (generally the ones which access data) publish Ivars 180. For instance, a Grid widget 60 will publish a rowid Ivar 180, which contains the rowid of the currently selected row in that grid and also publish one Ivar 180 for each column, containing data for the currently selected row in that column. Thus a grid called:

[0385] .main#1.subscreen#5.samplegrid#12 would publish the ivar

[0386] main#1.subscreen#5.samplegrid#12.rowid.

[0387] Some common features exist across entities 66. Each entity 66 supports a security parameter 56. This disables the entity 66 (requires permanently) if the correct permissions condition is not met, or an ivar 180 equality is not met.

[0388] There can be two main types of required parameters: overloadable parameters (O-params) and a complete set of all parameters (A-params), as given with examples in the sample entities 66 listed below. Over-loadable parameters can be changed depending on where the entity is reused.

[0389] Each application 30 generated by the generator 42 can have one top-level entity 66. The top-level entity 66 is of type Application and is never used as the “child” part of a relationship 70.

[0390] ‘Application’ Entities

[0391] Contained by: TOPLEVEL

[0392] Contains: Any

[0393] A-param: Id, name, appname, querysystem, delay, servername

[0394] O-param: None

[0395] The meaning of the parameters for these top level entities 66 are defined as:

[0396] name—Displayed title of the main window of the application;

[0397] appname—Name of the application;

[0398] querysystem—The system for querying the database;

[0399] delay—The delay between automatic refreshes of data; and

[0400] servername—The name of the server containing the database.

[0401] As a top-level entity 66, an Application entity 66 can't use Require or Conflict or have any security. It always gets created. Application entities 66 log the user 18 in as guest by default.

[0402] The user id ivar 180 is initialized to “guest” and the password ivar 180 is initialized to a null string.

[0403] Containers are entities 66 that visually contain other ones. Nearly all entities 66 can have children created in the relationships 70 table, but the children of a Grid, for example, are treated specially. On the other hand, Container Entities 66 can be used purely for layout purposes and don't change the way child entities 66 work. Since containers 66 can enclose other containers 66, you can nest them until your application 30 looks as desired in a predetermined manner.

[0404] ‘Screen’ Entities 66

[0405] Contained by: Container, Table

[0406] Contains: Any

[0407] A-param: Speedkey, name, require, delay, popup, security

[0408] O-param: None

[0409] The meaning of the parameters for these top level entities 66 are defined as:

[0410] name—Reference use;

[0411] delay—Used to set a refresh delay timer;

[0412] popup—Test used for popup tooltiptext in button widget 60 for when the entity 66 called as an applet; and

[0413] security—Check for security.

[0414] A Screen is a top-level window in the application 30. If the Screen is used as a child of any container object, it will be displayed as a button that you can click on to expose the new screen.

[0415] In a web interface 18, a screen can usually define a single generated HTML page.

[0416] ‘Group’ Entities

[0417] Contained by: Container, Table

[0418] Contains: Any

[0419] A-param: Id, name

[0420] O-param: None

[0421] The meaning of the parameters for these top level entities 66 are defined as:

[0422] Name—Name of the group.

[0423] The Group is a rectangle that contains other objects. You can use it to tweak the layout of your entities 66 in the current window. If the Group entity 66 has a occupied “name” field, then it appears as a visible frame with a subtitle. Otherwise, the group itself is completely invisible and only its child widgets 60 can be seen.

[0424] Middle tier 26 Entities 66

[0425] Contained by: Application, Screen

[0426] Contains: Query

[0427] A-param: Id, name

[0428] O-param:

[0429] The Middle tier Entity 66 class is currently used in generation of the sub-application 34 for the middle tier 26 and so is a parent to all labels and fields in the application 30.

[0430] Database Entities 66

[0431] Contained by: Application

[0432] Contains: Table

[0433] A-param: Id, name

[0434] O-param:

[0435] The Database Entity 66 class is used in generation of the sub-application 32 for the end tier 16 and so is a parent to all tables and fields in the application 30.

[0436] ‘TabSet’ Entities

[0437] Contained by: Container

[0438] Contains: Any

[0439] A-param: Require, name, id, security, row, column, fill, anchor

[0440] O-param: Row, column, fill, anchor

[0441] The meaning of the parameter for these tabset container entities 66 are defined as:

[0442] name—For reference use.

[0443] A TabSet entity 66 can appear using a “notebook tab” type of display. With a note-book, you can click on a tab at the top of a window and change what is currently displayed. A tabset 66 preferably should have only screen as children.

[0444] Read-only Entities 66 can be represented by

[0445] ‘Report’ Entities

[0446] Contained by: Container

[0447] Contains: None

[0448] A-param: Id, appname, name, file, width, height, code, require, row, column, fill, anchor

[0449] O-param: Row, column, fill, anchor

[0450] The meaning of the parameter for these tabset container entities 66 are defined as:

[0451] name—For reference use;

[0452] appname—Name of the Entity. Used in superclass JavaReport.java;

[0453] file—Name of file assosiated with the Entity Code Additional code supplied;

[0454] fill—Used for Layout Constraints;

[0455] row—Used for Layout Constraints;

[0456] column—Used for Layout Constraints; and

[0457] anchor—Used for Layout Constraints.

[0458] With the introduction of squery, the file 38 could also be useful for updating the database 20 a,b (“scripted transactions”). In the accounting application, we might use it to post a batch of transactions. Reports work (or should work) like this:

[0459] A Report entity in the appgenerator 42 is used as the child of a Screen, Group, or Tab when it appears as a pushbutton.

[0460] The application 30 requests a report from the query system by name; and

[0461] The query system then returns the display XML which is converted by the end user application 30 into something displayed on-screen of the device 18.

[0462] Another read only entity 66 is the ‘HTML’ Entities.

[0463] Contained by: Container

[0464] Contains: Any

[0465] A-param: Name, id, include, security, align, border, code

[0466] O-param: Height, width, row, column, rowspan, columnspan, fill, anchor

[0467] The meaning of the parameters for these read only entities 66 are defined as:

[0468] name—Name of the entity;

[0469] include—Contains path and filename of HTML document to be included in the application;

[0470] border—Sets the border of the HTML displayed on the page, if border is omitted, default border is 0;

[0471] alignment—Alignment of the HTML, if alignment is omitted, de-fault alignment is left; and

[0472] code—Contains HTML code to be displayed in the application.

[0473] An HTML object allows you to write your own HTML code, but only in JSP mode.

[0474] Another read only entity 66 is ‘Calc Box’ Entities.

[0475] Contained by: Container

[0476] Contains: None

[0477] A-param: Id, name, label, mode, require

[0478] O-param: Row, column, fill, anchor, Ivars

[0479] The meaning of the parameters for these read only entities 66 are defined as:

[0480] name—Name for the box;

[0481] label—Label on the box;

[0482] mode—One of ‘text’ or ‘password’, used with WAP applications; and

[0483] Ivars—as described above.

[0484] Calcbox entities 66 can be used as a way for the user 18 to view data in i-variables.

[0485] Another read only entitiy 66 is ‘Image’ Entities.

[0486] Contained by: Container, Table

[0487] Contains: None

[0488] A-param: Id, name, image, popup, require, messagetype, target, wapimage

[0489] O-param: Popup, messagetype, require, target

[0490] The meaning of the parameters for these read only entities 66 are defined as:

[0491] name—Name of entity;

[0492] image—Filename of image to be displayed;

[0493] popup—Text displayed when mouse is dragged over image;

[0494] messagetype, target—Message is sent out to target when a mouse is dragged over image, these two parameters are dependent on one another, hence must be used together; and

[0495] wapimage—Contains filename of image, (used in WAP mode).

[0496] An Image entity 66 displays the image filename given in its param field.

[0497] Further read only entities 66 are ‘Label’ Entities.

[0498] Contained by: Container

[0499] Contains: None

[0500] A-param: Name, id, require

[0501] O-param: Row, column, rowspan, columnspan, fill, anchor

[0502] The meaning of the parameters for these read only entities 66 are defined as:

[0503] Name—Caption of the label.

[0504] A Label object simply displays the text in its name field when it's used. Sometimes labels can be useful with security; for example, to display an “Access Denied” message when opening up a window. In the opposite case, to display a Group container that has useful information when access is allowed.

[0505] Another type of entity 66 is a Navigation Entity.

[0506] ‘SpeedNav’ Entity

[0507] Contained by: Container

[0508] Contains: Any

[0509] A-param: Id, name, require, parent, child, type

[0510] O-param: None

[0511] The meaning of the parameters for these read only entities 66 are defined as:

[0512] name—For reference use; and

[0513] type—Used to select style for HTML generation.

[0514] It corresponds to the menubar at the top of a window. The SpeedNav entity 66 can be used in the application 30, and can also be used as the standard navigator for that application 30. By default, SpeedNav can display all items in application.

[0515] A further navigation entity 66 is ‘SpeedMenu’ Entity.

[0516] Contained by: SpeedNav

[0517] Contains: Any

[0518] A-param: Speedkey, name

[0519] O-param: None

[0520] The meaning of the parameters for these read only entities 66 are defined as:

[0521] name—Name; and

[0522] Speedkey—Key used to select.

[0523] A further navigation entity 66 is ‘Graph’ Entity.

[0524] Contained by: Container

[0525] Contains: Any

[0526] A-params: Id, name, label, parent, child

[0527] O-params: Ivars, row, column, rowspan, columnspan, anchor, fill

[0528] The meaning of the parameters for these read only entities 66 are defined as:

[0529] name—Not normally used with Graphs;

[0530] label—Field name of label column;

[0531] parent—Field name of parent column; and

[0532] child—Field name of child column.

[0533] A visual entity 66 that displays the parent—child relationship in a cyclical manner, quite similar to navigators. Used in the Application Editor 46 to show entities 66 and relations 70.

[0534] A further type of entities 66 is Entities for User Input. The file 38 can accept user 18 input in three ways: the user 18 can click on Screen buttons, Notebook tabs (Tab entities), or on a SpeedNav entity 66 to open and close windows and move through the application 30; Record and Grid entities 66 allow the user 18 to edit data in SQL databases; and Input boxes allow the user 18 to enter data into input lines that are stored in i-vars 180. These can then be used in SQL queries or Require/Conflict entities to control the application's 30 behaviour.

[0535] One user input entity 66 type is ‘Preview’ Entities.

[0536] Contained by: Any

[0537] Contains: Query

[0538] A-param: Id, require

[0539] O-param: Ivars, row, column, rowspan, columnspan, anchor, fill

[0540] The meaning of the parameters for these read only entities 66 are defined as:

[0541] Ivars—see above description.

[0542] The Preview entity 66 is used to preview other entities 66. The preview entity 66 is available for the applet portion and is currently used in the generator 42.

[0543] Another user input entity 66 is ‘Login’ Entity.

[0544] Contained by: Container

[0545] Contains: None

[0546] A-param: Id, name, popup, require

[0547] O-param: Row, column, fill, anchor, rowspan, columspan, Ivars

[0548] The meaning of the parameters for these read only entities 66 are defined as:

[0549] name—Caption of button to be created; and

[0550] popup—Text displayed when cursor lingers over entity.

[0551] Creates, login or logout buttons.

[0552] Another input entity 66 is ‘Table’ Entities.

[0553] Contained by: Container

[0554] Contains: Any

[0555] A-param: Name, data, order, side, tables

[0556] O-param: Order, side, tables

[0557] The meaning of the parameters for these read only entities 66 are defined as:name—For reference use;

[0558] data—Data to fill in the table;

[0559] order—Not implemented;

[0560] side—Left or right in join; and

[0561] Tables—Alias.

[0562] These entities 66 Publishes: $table, $recno($table), $table. handle,$table.[fieldnames]. The Table entity refers to an SQL table named after the entity's shortname. If an SQL table is called “frogs” with fields “name”, “age”, “arms” and “legs”, you will create an entity of type Table with a shortname of “frogs”. Under it, you would attach Field entities with shortnames of “name”, “age”, and so on. The appgenerator 42 does a search for all Table entities when it builds the application 30, and makes sure all the appropriate SQL tables exist and contain the right fields. The SQL table in the database 20 a,b also has an additional magic field, handle, that acts as the table's primary key. All database access routines in the file 38 preferably depend on this primary key.

[0563] Another user input entity 66 is the ‘CustomTable’ Entity.

[0564] Contained by: Container

[0565] Contains: Any

[0566] A-params: Name, data

[0567] O-params: None

[0568] If you need to use the system 12 to access, for example, a legacy Fortran app with an encrypted back-end, you can write your own Table abstraction 148. CustomTableBase 154 exists as a bridge between the application 30 and the data source 20 a,b. It implements the methods in the AbstractTable 162, as described above.

[0569] Another user input entity 66 is the ‘Record’ Entities.

[0570] Contained by: Container

[0571] Contains: Query

[0572] A-param: Id, name, popup, require, Ivars, child, row, column, fill, anchor

[0573] O-param: Ivars, row, column, fill, anchor

[0574] The meaning of the parameters for these user input entities 66 are defined as:

[0575] id—For reference use;

[0576] name—For reference use;

[0577] popup—Used for mouseOverStr in superclass JavaWidget;

[0578] Ivars—see above description;

[0579] child—Used for Ivars 180;

[0580] fill—Used for Layout Constraints;

[0581] row—Used for Layout Constraints;

[0582] column—Used for Layout Constraints; and

[0583] anchor—Used for Layout Constraints.

[0584] Record entities 66 are also used as part of the main application 30 to provide an entry form for data into an SQL table. Tables have the notion of a “current record number” (stored in the Ivar rowid) and they display all records from the table in the database 20 a,b. The record entry form contains input fields taken directly from the table (Field entities), as well as CalcField entities that produce read-only values from SQL queries. To help communication between the Table entity, its Fields and CalcFields, the Table also publishes an Ivar 180 called $table (the shortname of the current Table entity) and a set of Ivars 180 called $table.FIELDNAME (one for each field in the table). Field entities each read and write their respective $table.FIELDNAME Ivars 180 based on user 18 input. The Table entity 66 collects them and saves or loads them from the SQL table whenever the current record number is changed.

[0585] Another input entity type 66 is ‘Recorder’ Entities.

[0586] Contained by: Any

[0587] Contains: None

[0588] A-param: Id, name, filename

[0589] O-param: None

[0590] The meaning of the parameters for these user input entities 66 are defined as:

[0591] Name—Reference use; and

[0592] Filename—Filename used for output file for the superclass Recorder.

[0593] This Entity 66 is in charge of the Recorder component. The recorder is used to record the actions of the user 18.

[0594] Another input entity type 66 is ‘Button’ Entity.

[0595] Contained by: Container

[0596] Contains: Any

[0597] A-params: Name, id, label, messagetype, target, request, require

[0598] O-params: Row, column, fill, anchor

[0599] The meaning of the parameters for these user input entities 66 are defined as:

[0600] name—Identifies the button. Not normally used with buttons;

[0601] label—The label on the button;

[0602] messagetype—The type of message that is to be sent. (i.e. Data, error . . . );

[0603] target—The channel on which the message will be sent; and

[0604] request—The value to give the message sent.

[0605] Sends a message when pressed. This message will be interpreted by other entities 66 to perform an action. (i.e. open a screen)

[0606] Another input entity type 66 is ‘Input Box’ Entities.

[0607] Contained by: Container

[0608] Contains: None

[0609] A-param: Id, name, label, hiddenlabel, datatype, mode, editable, require, popup

[0610] O-param: Row, column, fill, anchor, Ivars

[0611] The meaning of the parameters for these user input entities 66 are defined as:

[0612] name—Used in the superclass JSPInputBox.java. (in JSP and Wap mode);

[0613] label—The text that is to be displayed along with the InputBox;

[0614] datatype—The type of data that the input box will be expecting, if this parameter is not specified, it will be equal to the value of the mode parameter, possible inputs: password, text, combo, boolean, char, varchar, image;

[0615] popup—The text that is to be displayed when a mouse is dragged across the entity;

[0616] editable—Determines whether the inputbox is editable or not, bydefault inputboxes are editable; and

[0617] mode—Can be either text or password.

[0618] Inputbox are used as a way for the user 18 to enter data into Ivars 180.

[0619] Another input entity type 66 is ‘Grid’ Entities.

[0620] Contained by: Container

[0621] Contains: Query

[0622] A-params: Name, require, help

[0623] O-params: Ivars, row, column, rowspan, columnspan, anchor, fill

[0624] The meaning of the parameters for these user input entities 66 are defined as:

[0625] name—Name of the grid. Not visible.

[0626] A Grid entity 66 accesses SQL data in much the same way as a Table entity does, but it displays the data very differently. Instead of showing only one record at a time, a grid shows the data in a spreadsheet-like format with one record per row, and one field per column. Grids currently shows only Field and Calcfield entities that are its children. It also honours Require and Conflict entities that are parents of the Field enti-ties, so only the appropriate fields will be shown in the grid.

[0627] Another input entity type 66 is ‘Navigator’ Entities.

[0628] Contained by: Container

[0629] Contains: Query

[0630] A-param: Id, name, popup, label, parent, child, require

[0631] O-param: Row, column, fill, anchor, Ivars, rowspan, columnspan

[0632] The meaning of the parameters for these user input entities 66 are defined as:

[0633] name—Used as a title of the entity, (root of the tree);

[0634] popup—The text that is displayed when mouse is dragged over the entity;

[0635] label—Text displayed in list;

[0636] parent—If parent is specified then you have a recursive navigator; and

[0637] child—If only the child is specified it is a flat list.

[0638] A Navigator entity 66 displays a hierarchical tree, generated from an SQL query, and changes the Ivar $rowid according to the currently selected item in the tree. This changes the current row displayed by the appropriate Table or Grid entity. A Navigator has a Query entity as one of its children, which provides the data for the tree. Furthermore, Navigator entities 66 can also act like most other entities 66, as they do not have to be children of

[0639] Table or Grid entities 66.

[0640] Another input entity type 66 is ‘JavaAction’ Entities.

[0641] Contained by: Container

[0642] Contains: None

[0643] A-param: Id, name, popup, code

[0644] O-param:

[0645] The meaning of the parameters for these user input entities 66 are defined as

[0646] name—Used as a label for the button corresponding to this entity 66;

[0647] popup—Text is displayed when the mouse is dragged over the entity 66; and

[0648] code—Java code that is to be executed during runtime.

[0649] Allows you to execute java code from within the xml file 38. The entity 66 is displayed as a button, which when pressed executes the code that is written in the file 38.

[0650] Another input entity type 66 is ‘Field’ Entities.

[0651] Contained by: Table

[0652] Contains: Query

[0653] A-params: Id, name, datatype, security

[0654] O-params: None

[0655] The meaning of the parameters for these user input entities 66 are defined as:

[0656] name—Name of the field; and

[0657] datatype—Type of data to be held in the field (i.e. int).

[0658] A Field entity 66 is one field (also known as a column) in an SQL database, or a field in a non-SQL-based entry form. The “shortname” of the field entity 66 determines its I-variable name (which will be $table.shortname) and the field name used in SQL. The “param” field is the SQL data type to use, which can be any data type supported by SQL or one of the magic data types “money”, “phonenumber”, or “password.” A Field doesn't actually do SQL access itself; it merely sets an I-variable and expects its parent (a Table, Form, or indirectly, a Grid) to deal with loading or storing the value if necessary. If the Field has a Query as its child, the set of possible values is restricted to the data returned by the SQL query. The query is special and works like this: If it returns exactly two columns, then the first column is the data to store in the database, and the second column is the data to display for the user. For example, you could have 1 Blue 2 Red 3 Green and the field would display a drop-down box with the choices Blue, Red, and Green. If you selected Green, it would store ‘3’ in the I-variable, which eventually gets written to the database.

[0659] Another input entity type 66 is ‘CalcField’ Entities.

[0660] Contained by: Table

[0661] Contains: WVEPS

[0662] Publishes: $table.[shortname]

[0663] A-params: Id, name, code(to be added)

[0664] O-params: None

[0665] The meaning of the parameters for these user input entities 66 are defined as:

[0666] name—Name for the field.

[0667] CalcFields can be used to represent aggregate functions in SQL such as SUM( ) and AUG( ).

[0668] A further type of entities 66 are ‘Invisible’ Entities that Send or receive messages.

[0669] ‘Publish’ Entities

[0670] Contained by: Application

[0671] Contains: None

[0672] A-param: Id, name, value, Ivars

[0673] O-param:

[0674] The meaning of the parameters for these user input entities 66 are defined as:

[0675] Ivars—Name of the Ivar to be published; and

[0676] value—Value of the Ivar variable to be published.

[0677] A Publish entity creates an Ivar 180 named after the entity's 66 shortname field, with the contents defined by its “param” field. Note that Table and Grid entities 66 also publish Ivars 180, but they are named something like “tablename.fieldname”. There is no “tablename.” in an Ivar 180 created by Publish, although you can simulate it by using something like “frogs.legs” as the shortname. Publish entities 66 aren't actually displayed anywhere in the generated application 30; they're invisible, but behave as if present.

[0678] Another type of invisible entities 66 are ‘Localization’ Entities.

[0679] Contained by: Application

[0680] Contains: None

[0681] A-param:

[0682] O-param:

[0683] Localization entity 66 allows you to display text in several different formats, according to the mapping selected. For example: <entity ID=“localeTable” type=“Localization”>

[0684] <localization>

[0685] <locale name=“default”>

[0686] <string refid=“1”>A label</string>

[0687] <string refid=“2”>A screen</string>

[0688] <string refid=“3”>Popur Label</string>

[0689] </locale>

[0690] <locale name=“other”>

[0691] <string refid=“1”>A similar yet distinct label</string>

[0692] <string refid=“2”>Le Screen</string>

[0693] <string refid=“3”>ToolTip</string>

[0694] </locale>

[0695] </localization>

[0696] </entity>

[0697] <entity ID=“labelscreen” type=“Screen”>

[0698] <param name=“name”><ref>2</ref></param>

[0699] <param name=“popup”><ref>3</ref></param>

[0700] <child name=“applabel”></child>

[0701] </entity>

[0702] In this example the parameter name of the entity 66 screen (labelscreen) is referenced to “Screen”.

[0703] Another type of invisible entity 66 is ‘Neuron’ Entities.

[0704] Contained by: Container

[0705] Contains: Query

[0706] A-param: Id, require, name, in, middle, out

[0707] O-param: Row, column, fill, anchor

[0708] The meaning of the parameters for these user input entities 66 are defined as:

[0709] top—Parameter specifies channel on which neuron is listening;

[0710] middle—Contains java code to be executed when neuron is fired;

[0711] out—most applications 30 contain the tag.

[0712] Neuron is a listener that listens to a channel specified in the ‘in’ parameter. When it receives the message it executes the Java code specified in the middle parameter.

[0713] Another invisible entity 66 is the ‘Help’ Entity.

[0714] Contained by: Container

[0715] Contains: Any

[0716] A-param: Id, name

[0717] O-param: None

[0718] Instantiates a help system. All entities 66 contained within the help entity should have a help parameter.

[0719] Another invisible entity 66 is the ‘Cursor’ Entity.

[0720] Contained by: Container

[0721] Contains: None

[0722] A-param: Id, name, require

[0723] O-param: None

[0724] The meaning of the parameters for these user input entities 66 are defined as:

[0725] name—Name for cursor, not normally used.

[0726] Is basically a record which has no visible parts. Cursor entities currently exist in JSP.

[0727] Another invisible entity 66 is the ‘EntityCursor’ Entity.

[0728] Contained by: Container

[0729] Contains: None

[0730] A-param: Id, name, require

[0731] O-param: None

[0732] The meaning of the parameters for these user input entities 66 are defined as:

[0733] name—Name for cursor, not normally used.

[0734] This entity adds an Entity Cursor to the resultant app 30. This can/should only be done in the application editor 46.

[0735] Another invisible entity 66 is the ‘XMLParsing’ Entities.

[0736] Contains: None

[0737] An Entity 66 which takes XML input as string and Parses the XML code 38.

[0738] Another type of entity are the Database Query Entities, or ‘QJoin’ Entities

[0739] Contained by: Container

[0740] Contains: Any

[0741] A-param: Name, Style, Condition

[0742] O-param: none

[0743] The meaning of the parameters for these user input entities 66 are defined as:

[0744] Name;

[0745] Style; and

[0746] condition.

[0747] QJoin entity 66 as a child of the query. The QJoin entity 66 requires two children, the left table, and the right table in the join. The two parameters required are: style(left, right, full) condition: which is what links the two tables together. I.e. table1.name=table2.name The table relationships can have one parameter: tableas which defines an alias for the table, when joining a table with itself.

[0748] Another type of database query entity 66 is the ‘QJoinRecursive’ Entities.

[0749] Contained by: Container

[0750] Contains: Any

[0751] A-param: Name, style, condition

[0752] O-param: None

[0753] The meaning of the parameters for these user input entities 66 are defined as:

[0754] Name;

[0755] Style; and

[0756] condition.

[0757] The recursive join option allows you to create extra rows which create additional rows in the result set to enumerate many possible parent child combinations.

[0758] Another type of query entities 66 are ‘Query’ Entity.

[0759] Contained by: Containers, Field Entity, Navigator Entity, Grid Entity, Record Entity

[0760] Contains: None

[0761] A-param: Id, name, where, group

[0762] O-param: None

[0763] The meaning of the parameters for these user input entities 66 are defined as:

[0764] id—Reference use;

[0765] where—Where Constraints;

[0766] group—Group by clause; and

[0767] order—Order by clause.

[0768] This Entity corresponds to a SQL Query It is used in the following classes: QuertySet.java RequireQuery.java SQueryBase.java.

[0769] Another type of query entity 66 is ‘CustomQuery’ Entity.

[0770] Contained by: Container

[0771] Contains: None

[0772] A-param: Id, name, where, group, order

[0773] O-param: None

[0774] A custom Query is used depending on what kind of access to the datasource 20 a,b you are using.

[0775] Another type of query entity 66 is ‘QueryBase’ Entities.

[0776] Contains: None

[0777] An Entity 66 which is essentially a base form for the Query Entity.

[0778] Accordingly, the above described sample entities 66 can be used with appropriate relationships 70 to control the presentation and functionability of widgets 60 on an interface screen 58 of the interface of the device 18, as well as provide operational behavior and structure to the components of the end tier 14 and middle tier 26 of the system 10. This integrated operational structure is supplied by the subprograms 32, 34, 36 of the application 30, which can be generated for a selected combination of hardware/software platforms in the tiers 14, 16, 26 according to the file 38 parameters 40, 44, as processed by the generator 42.

[0779]FIG. 11 shows example deployment configurations of the application 30 over the various tiers 14, 16, 26 of the system 10. For example, using the pass through 24 system of the middle tier 26 facilitates the access of the devices 18 directly to inhouse data servers, low to medium demand data driven websites, and low to medium cell phone data access. In addition, other example deployments could be through the EJB server 28 a of the middle tier 26, thereby facilitating access of the devices 18 for inhouse EJB systems, intranet applications, high demand data driven websites over the internet, and large volume cell phone data access. As well, middle tier technology 26 using the COM server 28 b could be similar to that provided by the EJB server 28 a in deployment configuration. Furthermore, custom deployments using the custom queries 148 could be to interface various JAVA, web, or cell phone graphical user interfaces on the various devices 18 to custom data stores 20 a, b.

[0780] Referring to FIG. 12, in operation of the application development system 12 the software developer constructs the abstract notation representation file 38 through input of the parameters 40, 44 at step 182. The file 38 is the declaration of all the various components to be found in the end application 30, such as but not limited to grids, records, screens, database queries, and database tables. These components or entities 66 are hooked or logically linked to one another through relationships 70, as described above, which is accomplished by a series of parent child relationships 70. Accordingly, the entity 66 can be reused through the relationships 70, such as selecting an employer from a list and displaying relevant information in an accompanying grid. The input parameters can also be used to program custom business logic using message based architecture, whereby the software developer can use the custom components of neurons to coordinate the acceptance, processing, and sending out of messages used during the access of the databases 20 a, b from the devices 18 of the system 10. Furthermore, the parameters 40, 44 can be used to define custom reports to perform complex functions, whereby both the neurons and the reports can be made up of procedural XML. Furthermore, internationalized strings can be part of the input parameters 40, 44 to include the addition of functionality in multiple languages, such as using English and French labels, such as using the example XML code below.

EXAMPLE XML

[0781] 01 <entity ID=“localeTable” type=“Localization”> 02 <localization> 03 <locale name=“english”> 04 <string refid=“100”>Manage Exchanges</string> 05 <string refid=“101”>Active Exchanges</string> 06 <string refid=“102”>Manage Hardware</string> 07 <string refid=“103”>Manage Hardware</string> 08 <string refid=“104”>Status for Exchange</string> 09 <string refid=“105”>Test Device</string> 10 </locale> 11 <locale name=“french”> 12 <string refid=“100”>Contrôlez les Échanges</string> 13 <string refid=“101”>Les Échanges Actifs</string> 14 <string refid=“102”>Manage Hardware</string> 15 <string refid=“103”>Contrôlent Le Matériel</string> 16 <string refid=“104”>Status de l'Échange</string> 17 <string refid=“105”>Test l'Appareil</string> 18 </locale> 19 </localization> 20 </entity>

[0782] Accordingly, the example code contains the definition of labels to be used by the graphical user interface of the device 18, wherein lines 3 through 10 enclose the definition of English labels while lines 11 through 18 enclose the definition of French labels.

[0783] Referring to FIG. 12, the file 38 is then read into the application generator 42 and the XML description is parsed at step 184 and its syntax is validated through the checking of errors. The next step at 186 is to construct an inmemory representation of the input file 38 by the generator 42, whereby each target language of the file 38 is represented by an object. At the entity iterator stage 188, the generator 42 accesses each individual entities 66 code in the memory model to generate code for each and every object, which is used to generate individual language stubs or platform indicator for the beginning and end of the program 30, as well as processing the corresponding XML description 38 to facilitate generation of application subprograms 32, 34, 36 for the corresponding target languages or platforms selected. This process is used in conjunction with the parameters 40, 44 for the selection of the corresponding tier at step 190 and the selection of corresponding tier target language at step 192. Accordingly, each object type in the inmemory model of step 186 has a group of corresponding entities which are used to define the code to be generated for the corresponding entity group in the selected platforms. Furthermore, the parameters of the entity 66 are parsed and interpreted at step 194 and then the output code is generated at step 196 for a selected tier output file 32 by which the central platform application 30 is generated. The abstract notation form of the data contained in the file 38 is thereby transformed to selected language or platform notation as determined by the input parameter 40, 44 and stubs. Accordingly, the next series or entity group represented by the next language or platform stub, positioned by the target language object, at the beginning and end of the entity group is processed by the entity iterator 188 through the above mentioned steps 190, 192, 194, 196 to output the output file 34 for the next tier platform. The entity iterator 188 process continues until all of the output files have been generated for the selected number of tiers 14, 16, 26 (and others if desired) to complete the central application platform 30. Accordingly, the output 30 is a series of source files 32, 34, 36 split across the tiers 14, 16, 26 of the application 30, which can be compiled on specified target platforms that may or may not be in the same language or on the same platform or machine. Furthermore, it should be noted that the source code of the application 30 can be generated at the time of program building is set up once per end user access. Therefore, the development system 12 facilitates the output of a series of programs 32, 34, 36 each of which potentially executes in a different language or on a different machine which corresponds to a distributed n-tier application platform 30. The system 12 can give auto generation of the application 30 for different platforms, much as but not limited to JAVA, Tcl, Php, C, their middle tier 26 components COM 28 b, EJB 28 a, and their final database schemas 20 a, b.

[0784] Referring to FIG. 13, further embodiment of the system 12 can include a computer system 200 comprising a processor 202 coupled to a storage medium 204 and memory 206. The processor 202 monitors the download or transfer of the description file module 208, the editor module 210, and the input module 212 to be used to generate the application file 30. The processor is also coupled to a display 214, which can be used by the software designer to coordinate the generation of the file 30. An input device 216, such as a keyboard, a mouse, or a voice activated device can be used to input data and other commands into the processor 202 to facilitate in the generation of the file 30. Furthermore, the display 214 could be touch sensitive for use as an input device 216. A computer readable storage medium 204 is coupled to the processor 202 for providing an operating system or the software of the other modules 208, 210, 212 to the computer 200. The storage medium 204 could also represent downloaded data accessed over a network. The computer readable medium 204 can include hardware and/or software, such as by way of example only, magnetic discs, magnetic tape, optically readable media, such as CD ROMs, and semi conductor memory, such as PCMCIA cards. In each case, the medium 204 may take the form of a portable item such as a small disc, floppy diskette, cassette, or may take the form of a relatively large or immobile item such as a hard disk drive, a solid state memory card, or RAM provided in the computer system 200. It should be noted that the above listed example mediums 204 can be used either alone or in combination. Accordingly, the operation of the system 12 can be provided by software containing the above system 12 features as software modules.

[0785] Although the system 10 and 12 have been described with reference to certain specific embodiments, various modifications thereof will be apparent to those skilled in the art without departing from the spirit and scope of the invention as outlined in the claims appended hereto. 

The embodiments of the invention in which an exclusive property or privilege is claimed are defined as follows:
 1. A multi-tier application system for generating a central application for deployment on a predetermined combination of selected components, the system comprising: a) an abstract notation description file to contain data for the central application; b) an editor for entering a selected set of input parameters to provide the data; and c) an application generator for transforming the data from the abstract notation to a selected platform notation corresponding to the selected components, the selected notation contained in the central application; wherein the deployment of the central application, monitors the communication of component data between the selected components.
 2. The system according to claim 1, wherein at least two of the selected components having different platforms.
 3. The system according to claim 2, wherein the description file including platform indicators in the data capable of representing multiple applications of different platforms corresponding to the selected components.
 4. A method for generating a central application for deployment on a predetermined combination of components selected from a multi-tier environment, the method comprising the steps of: a) selecting input parameters for representing data for the central application; b) combining the input parameters for producing an abstract notation description file comprising the data; c) transforming the data from the abstract notation to a selected platform notation corresponding to the selected components; and d) generating the central application containing the platform notation; wherein deployment of the central application monitors the communication of component data between the selected components.
 5. A computer program product for generating a central application module for deployment on a predetermined combination of selected components, the product comprising: a) a computer readable medium; b) an abstract notation description module stored on said computer readable medium for containing data for the central application module; c) an editor module coupled to the description module for entering a selected set of input parameters to provide the data; d) an application generator module coupled to said description module for transforming the data from the abstract notation to a selected platform notation corresponding to the selected components; and e) the central application module coupled to the generator module for receiving the selected platform notation; wherein the deployment of the central application module monitors the communication of component data between the selected components.
 6. A multi-tier application system for generating a central application for deployment on a predetermined combination of selected components having different platforms, the system comprising: a) an abstract notation description file to contain data for the central application, the description file capable of representing multiple sub-applications of different platforms; b) an editor for entering a selected set of input parameters to provide the data, the data including platform indicators; and c) an application generator for transforming the data from the abstract notation to a plurality of selected platform notations corresponding to the platform indicators, the selected notations representing different platforms contained by the central application; wherein the deployment of the central application as a series of the sub-applications on corresponding tiers containing the selected components facilitates the monitoring of communication of component data between the selected components. 